PostgresBench: A Reproducible Benchmark for Postgres Services

ClickHouse, known for its high-performance systems, has developed a managed Postgres service focusing on speed from the outset, offering one of the fastest managed Postgres services available. This service complements ClickHouse's analytical capabilities with Postgres handling transactional workloads, forming a robust data stack for SaaS and AI applications. To evaluate this service, ClickHouse created PostgresBench, a benchmark modeled after ClickBench, to compare managed Postgres services using a transparent, reproducible methodology. Built on pgbench, it simulates common transactional patterns and tests various configurations to reflect real-world usage, capturing metrics like TPS and latency. The benchmark highlights Postgres managed by ClickHouse's superior performance due to its NVMe-backed storage, which minimizes I/O latency, a critical factor in sustaining high-performance levels in OLTP workloads. The results are publicly available, allowing for community validation and contributions to enhance the benchmark's comprehensiveness and fairness.