Performance benchmarks

# Run benchmark (read-only, prepared statements)
pgbench -c 32 -j 16 -T 300 -S -M prepared -P 30
```

## Performance summary[​](#summary "Direct link to Performance summary")

### Key findings[​](#key-findings "Direct link to Key findings")

Across all three benchmark scenarios, Postgres managed by ClickHouse consistently delivered superior performance:

1. **IO-intensive read+write workloads**: 4.3-4.5x higher TPS compared to RDS (16k IOPS) and Aurora IO Optimized
2. **IO-intensive read workloads**: 9x higher TPS compared to RDS with 16k IOPS
3. **CPU-bound workloads**: 12% higher TPS than RDS

### When Postgres by ClickHouse excels[​](#when-it-excels "Direct link to When Postgres by ClickHouse excels")

Postgres by ClickHouse is ideal for applications that:

- **Power fast-growing AI-driven workloads** requiring high-throughput data ingestion with frequent upserts, real-time feature updates, and analytics out of the box through seamless integration with ClickHouse for OLAP workloads
- Perform frequent writes, updates, or mixed read/write operations
- Need predictable, high-performance storage
- Are currently constrained by IOPS limits on traditional managed Postgres services

**If you expect analytics later** and anticipate deeper ClickHouse integration—common in modern AI workloads where transactional data feeds real-time dashboards, feature stores, and ML pipelines—**Postgres by ClickHouse should be your default go-to choice**. The native integration eliminates complex ETL pipelines and enables seamless data flow between your operational database and analytical queries.

### NVMe architecture advantage[​](#nvme-advantage "Direct link to NVMe architecture advantage")

The performance advantage comes from the fundamental architectural difference:

|  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Aspect NVMe Storage (Managed Postgres) Network-Attached Storage (Provisioned IOPS)|  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | **IOPS** 100k to virtually unlimited 16,000 provisioned|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | **Network hops** Zero (local device) Every disk operation requires network round trip|  |  |  | | --- | --- | --- | | **Performance scaling** Scales linearly with concurrency Limited by provisioned IOPS | | | | | | | | | | | |

For more details on the performance benefits of NVMe storage, see [NVMe-powered performance](/docs/cloud/managed-postgres#nvme-performance).

## Cost-effectiveness[​](#cost-effectiveness "Direct link to Cost-effectiveness")

Beyond raw performance, Postgres managed by ClickHouse offers superior price-performance:

- **Higher throughput per dollar**: Achieve 4-9x more TPS compared to RDS with 16k provisioned IOPS and Aurora IO Optimized
- **Predictable costs**: No need to provision additional IOPS capacity—unlimited local IOPS included
- **Lower compute requirements**: Achieve target performance with smaller instance sizes due to efficient I/O
- **Reduced need for read replicas**: Higher single-instance throughput reduces need for horizontal scaling

For workloads currently constrained by IOPS limits, switching to Managed Postgres can eliminate the need for expensive provisioned IOPS or IO-optimized configurations while delivering significantly better performance.

## References[​](#references "Direct link to References")

The complete benchmark data, configurations, and detailed metrics are available in our [benchmark results spreadsheet](https://docs.google.com/spreadsheets/d/17TLWmwNKZb3Ie1vSQqvjtqByHskvoX6CF2eQ_FRx1cA/edit?gid=845104392#gid=845104392).

## Additional resources[​](#resources "Direct link to Additional resources")

- [PeerDB: Comparing Postgres managed services](https://blog.peerdb.io/comparing-postgres-managed-services-aws-azure-gcp-and-supabase)
- [pgbench documentation](https://www.postgresql.org/docs/current/pgbench.html)
- [Managed Postgres overview](/docs/cloud/managed-postgres)
- [Scaling your Postgres instance](/docs/cloud/managed-postgres/scaling)

- [Benchmark overview](#overview)- [Benchmarks](#benchmarks)
    - [Test 1: IO Intensive - Read+Write (500 GB dataset)](#test1)- [Test 2: IO Intensive - Read-Only (500 GB dataset)](#test2)- [Test 3: CPU Intensive (data fits in memory)](#test3)- [Performance summary](#summary)
      - [Key findings](#key-findings)- [When Postgres by ClickHouse excels](#when-it-excels)- [NVMe architecture advantage](#nvme-advantage)- [Cost-effectiveness](#cost-effectiveness)- [References](#references)- [Additional resources](#resources)

Was this page helpful?