Skip to content
Hacker News front page

pgrust rebuilt Postgres's query engine and made it 300x faster for analytics

Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD

pgrust 0.2 is 300x faster than vanilla Postgres on Clickbench and even beats ClickHouse. The main lever is a rewritten query engine that replaces the row-at-a-time Volcano model with batching, operator fusion, and SIMD. A toy Rust executor shows the baseline: summing 500M rows takes 1.3 s with the Volcano model. Batching cuts much of the per-row function-call overhead. The post explains that Postgres was built when disk I/O was the bottleneck; today CPU and memory bandwidth matter more. The article does not disclose the final pgrust time for the 500M-row sum, nor does it detail the operator-fusion and SIMD implementations.

Why it matters: pgrust 0.2 rewrites the Postgres query engine with batching, operator fusion and SIMD, hitting 300x native speed on Clickbench and beating ClickHouse.

Read the original ↗Export Markdown