Postgres's 1980s query engine gets a Rust rewrite and a 300x speedup

pgrust is a Rust-based reimplementation of Postgres that achieves 300x faster analytical query performance than vanilla Postgres on Clickbench, even outpacing ClickHouse. The article breaks down how the query engine was optimized: replacing the row-at-a-time Volcano model with batched processing, fusing operators to eliminate intermediate overhead, and leveraging SIMD instructions. These changes target CPU and memory bandwidth bottlenecks that have become dominant as datasets moved into RAM and disks got faster, rendering Postgres's 1980s-era architecture increasingly misaligned with modern analytical workloads.