
How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL
1. Introduction In the past few months, we’ve heard consistent feedback from users and partners: while our goal of providing a scalable, high-performa...
pgrust 0.2 is 10x faster than its predecessor, 30% faster than Postgres on OLTP workloads, and 300x faster on the Clickbench analytical benchmark.
The performance gain primarily comes from replacing Postgres' row-at-a-time Volcano model query engine with a batched executor that reduces per-row function call overhead. Additional optimizations include operator fusion and SIMD vectorization to lower CPU and memory bandwidth usage per query.