With the release of pgrust v0.4-beta, our new query engine, Gravity, is now as much as 3x faster than ClickHouse on ClickBench, the benchmark that ClickHouse themselves designed to show off how fast ClickHouse is. Even better, Gravity achieves … Read the rest
pgrust v0.4-beta: Gravity, Columnar Indexes, Automatic Memory, and Developing in the Open
Today we are releasing pgrust v0.4-beta. As the name suggests, this is a beta release rather than the final v0.4 release, and we are sharing it now to show you what’s coming in v0.4 while we finish stabilizing the remaining … Read the rest
JIT Compiling Code in 5μs
Rebuilding Postgres for 300x faster analytics: batching, operator fusion, and SIMD
Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical … Read the rest
Postgres in Rust: three dead ends before we passed 100% of the regression suite
tl;dr After four attempts and dropping $100k, we succeeded in using Opus to rewrite Postgres in Rust. We defined a number of skills and were able to build a repeatable process to rewrite Postgres files into Rust. After running up … Read the rest
pgrust passes 100% of the Postgres regression tests
pgrust is a Postgres rewrite in Rust that I’ve been working on with my friend Jason Seibel. It targets compatibility with Postgres 18.3, passes the PostgreSQL regression tests, and now also passes the isolation tests.
It is disk compatible with … Read the rest
The four horsemen behind thousands of Postgres outages
Postgres is great, but there are some very common problems that people have that can pretty easily lead to outages with Postgres. These aren’t just theoretical issues. From talking to a lot of startups, these are the things that actually … Read the rest
pgrust update: at 67% Postgres compatibility, and accelerating
… Read the restIt’s been a week since I published the original pgrust post. pgrust is my attempt to rewrite Postgres in Rust. My ultimate goal is to build a database that is safer to work with so that I can work
pgrust: Rebuilding Postgres in Rust with AI
… Read the restI’ve written dozens of blog posts about Postgres internals. Postgres is one of the greatest databases out there. But from chatting with a lot of my friends at startups, I’ve seen consistent challenges. Two weeks ago I started rebuilding
Simple Rules for Building Simple Systems
Once a design of a system meets all the business constraints necessary, my next priority is to make the system as simple as possible. By simple, I mean a system that is both easy to understand and easy to change. … Read the rest