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. pgrust update: at 67% Postgres compatibility, and accelerating

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

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