Skip to content
Tech News
← Back to articles

PostgresBench: A Reproducible Benchmark for Postgres Services

read original get PostgreSQL Performance Tuner → more articles
Why This Matters

PostgresBench introduces a transparent, reproducible benchmark for evaluating managed Postgres services, emphasizing performance in transactional workloads. This initiative helps consumers and the industry better compare service providers, ensuring transparency and fostering improvements in database performance. It aligns with the broader goal of building high-performance, reliable data infrastructure for SaaS and AI applications.

Key Takeaways

For years, we have focused on building fast systems. ClickHouse is an example of that focus. Performance is not a feature we add later. It is a core design goal from the start.

We applied a similar approach when building our managed Postgres service. The result is offering one of the fastest managed Postgres services to our customers. Postgres handles transactional workloads, while ClickHouse handles analytical workloads. Together they form a unified data stack enabling a "best-of-breed" foundation SaaS and AI applications.

With that in mind, it felt natural to evaluate it the same way we evaluate ClickHouse: with a public, reproducible benchmark.

That is why we built PostgresBench, a benchmark to compare managed Postgres services.

From ClickBench to PostgresBench #

ClickBench is a widely referenced OLAP benchmark. It benchmarks more than 40 databases using a transparent and reproducible methodology. All queries, datasets, and results are public and anyone can validate the numbers or submit improvements.

PostgresBench applies the same methodology to transactional Postgres workloads. The rules are straightforward:

Use a well-understood, standard workload

Keep infrastructure consistent across all services tested

Publish all configuration so results can be reproduced

... continue reading