pgrust

Engineering notes

Inside the Postgres rewrite

Compatibility work, query-engine performance, JIT compilation, and what we learn rebuilding PostgreSQL in Rust.

  1. JIT Compiling Code in 5μs

    Build a copy-and-patch JIT compiler in Rust, generate ARM64 machine code, and benchmark it against an interpreter and handwritten implementation.

  2. Rebuilding Postgres for 300x faster analytics: batching, operator fusion, and SIMD

    How batching, operator fusion, and SIMD made pgrust analytical queries hundreds of times faster than PostgreSQL.

  3. Postgres in Rust: three dead ends before we passed 100% of the regression suite

    Four attempts, three dead ends, and the process that produced a Rust rewrite passing PostgreSQL's full regression suite.

  4. pgrust passes 100% of the Postgres regression tests

    pgrust reaches full PostgreSQL regression and isolation test compatibility.

  5. The four horsemen behind thousands of Postgres outages

    Four recurring PostgreSQL failure modes and how pgrust is designed to address them.

  6. pgrust update: at 67% Postgres compatibility, and accelerating

    How parallel coding agents, shared build artifacts, and a merge queue accelerated the PostgreSQL rewrite.

  7. pgrust: Rebuilding Postgres in Rust with AI

    The first two weeks of rebuilding PostgreSQL in Rust with coding agents, from the parser to a browser demo.