Postgres managed by ClickHouse | One stack for transactions and analytics<br>Open searchOpen region selectorEnglish<br>Japanese

48.1kSign inGet started

Postgres managed by ClickHouse

Fast, scalable, enterprise-grade Postgres, natively integrated with ClickHouse.<br>Built for real-time and AI-driven applications.<br>A Unified Data Stack that combines Postgres for transactions and ClickHouse for analytics, with no added complexity!

Start free trialLearn more

Trusted by

Why Postgres managed by ClickHouse?<br>NVMe performance<br>Enterprise-grade Postgres on local NVMe storage. Microsecond latency, practically unlimited IOPS, consistent performance without network jitter.

Up to 10× faster performance for I/O-heavy workloads

Ultra-low disk latency: μs vs ms

No EBS throttling or limits

Architecture validated by Datadog, Instacart

ClickHouse integration<br>Postgres meets ClickHouse, 100x faster real-time analytics. Unify transactional and analytical workloads.

Native CDC: sync Postgres data to ClickHouse, in a few clicks.

Blazing fast replication with seconds latency

pg_clickhouse: unified query layer to build apps powering transactions and analytics.

Comprehensive query pushdown with pg_clickhouse - JOINs, aggregations and more.

Enterprise grade Postgres built with Ubicloud<br>Postgres built for mission-critical workloads. No compromises on availability, reliability, security or standard managed service features. Built along with seasoned Postgres experts at Ubicloud.

High availability with up to 2 standbys

Automatic backups with WAL archival to S3

Forks & Point-In-Time-Recovery (PITR)

End-to-end encryption and private networking

Backed by ClickHouse Cloud Trust

Open-source first<br>Built on open-source principles. Every component is open-source, no vendor lock-in, full control of your data stack.

Postgres for transactions

ClickHouse for analytics

PeerDB for CDC

pg_clickhouse for unified query layer

Postgres managed service powered by Ubicloud

To learn more, read our blog ->->

Why teams pick Postgres managed by ClickHouse<br>Real numbers, real production workloads.

Running 8.5 TB of hot data in Postgres, with super low-latency on NVMe

ClickHouse Postgres has been an incredible fit for us as we migrated from Aurora and scaled our production workload. We’re now running around 8.5 TB of hot data in Postgres (...)

The performance has been simply impressive, and the ClickHouse team has been a great partner.

ClickHouse's raw performance with the ubiquitous compatibility of Postgres.

ClickHouse is helping us simplify a bold Customer Data Platform architecture by leveraging Postgres as a universal interface.

With pg_clickhouse, ClickHouse becomes a plug-and-play database for virtually any third-party tool (...) It’s the best of both worlds.

Multi-terabyte workloads moved, without the operational complexity we expected.

We moved multiple multi-terabyte workloads from RDS and Aurora to ClickHouse Postgres with hands-on support from the ClickHouse team.

Given the scale and complexity of our cybersecurity data sources, reliability and price-performance were critical (...) The team has been a great partner across several complex deployments.

Unified data stack<br>Combine Postgres for transactions with ClickHouse for analytics to deliver best-in-class performance and scalability with minimal operational overhead.<br>Architectural pattern followed by thousands of companies like GitLab, Cloudflare, Instacart, and LangChain.

NVMe-backed Postgres for OLTP<br>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.<br>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.<br>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.

Blazing-fast replication<br>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.<br>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.<br>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.

Unified query layer<br>Query ClickHouse directly from Postgres using the pg_clickhouse extension. No proxies, no new...