Postgres managed by ClickHouse

Unlock up to 10× faster Postgres performance with NVMe storage built for I/O-intensive workloads. Microsecond-level latency and millions of IOPS eliminate disk bottlenecks for high-throughput transactional applications.

Unlike traditional SSDs that cap out at a few hundred thousand IOPS, NVMe scales effortlessly, delivering lower tail latencies and faster system operations like VACUUM, checkpoints, and logical replication.

High availability is built in by design, with up to two dedicated standby instances reserved exclusively for HA. Read replicas are offered separately to preserve reliability. Automatic backups and point-in-time recovery (PITR) with WAL archiving ensure robust disaster recovery.

Replicate Postgres data to ClickHouse in real time to unlock up to 100× faster analytics. With replication latency as low as a few seconds, your data is analytics-ready almost immediately.

The pipeline supports both initial snapshots for existing datasets and CDC-based incremental updates. It’s powered by the ClickPipes Postgres CDC connector, proven in production by hundreds of enterprises moving hundreds of terabytes per month.

Coming next: more native CDC capabilities, including sub-second replication latency, reliable slot flushing through ongoing transaction replication, and other enhancements, exclusive to Postgres managed by ClickHouse.

Query ClickHouse directly from Postgres using the pg_clickhouse extension. No proxies, no new query layer to manage. Postgres becomes a single interface for both transactions and analytics.

Queries are transparently pushed down to ClickHouse for maximum performance, supporting joins, filters, aggregations, and functions. Today, 14 of 22 TPC-H queries are fully pushed down, delivering 60×+ speedups.

Pushdown support continues to expand to CTEs, window functions, and more, enabling fast analytics from the Postgres layer while ClickHouse handles execution behind the scenes.