Making Postgres 300x faster for 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 databases, pgrust is 300x faster than Postgres. It’s even ahead of Clickhouse! The query engine is […]
327 points by poly2it 75 days ago malisper.me 164 comments

Summary

The latest version of pgrust significantly boosts performance, achieving impressive speed gains over both previous iterations and Postgres, particularly in analytical benchmarks. With a reported 300x increase in speed for analytics, it positions itself as a strong contender against established databases like Clickhouse.

Comments (164 of ) ⌛

Loading more comments... ⌛
Scroll down to load more comments
No comments available.
Type to search HN and engineering blog articles
Press Escape to close  |  ↑↓ to navigate  |  Enter to open