pgrust

Engineering notes

Inside the Postgres rewrite

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

  1. pgrust v0.3: the bug-smashing release

    On a held-out corpus of 164,000 cases, divergences from Postgres fell from 1,454 in v0.2 to 11 in v0.3.

  2. 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.

  3. Rebuilding the Postgres query engine: batching, operator fusion, and SIMD

    How batching, operator fusion, and SIMD change the Postgres query engine, with small implementation examples.

  4. 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.

  5. pgrust passes 100% of the Postgres regression tests

    pgrust reaches full PostgreSQL regression and isolation test compatibility.

  6. The four horsemen behind thousands of Postgres outages

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

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

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

  8. 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.