Skip to content
Download full logoDownload logomark

ClickHouse Managed Postgres

Run Postgres up to 10x faster, natively integrated with ClickHouse.

Start with ClickHouse Managed PostgresExplore the documentation

ClickHouse Managed Postgres runs alongside ClickHouse on one platform, running Postgres up to 10x faster with sub-second replication through WalShadow (private preview) and one query interface.

Xata

ClickHouse Managed Postgres is now GA, and the Xata acquisition brings agentic capabilities to the service

AWSAvailable
Google CloudPrivate preview
AzurePlanned
Postgres Dashboard

Trusted by

ClayPhysical IntelligenceQuinto AndarDo ControlSterling LabsTrainyDavid AIMpathicSocial PrufPrediko
ClayPhysical IntelligenceQuinto AndarDo ControlSterling LabsTrainyDavid AIMpathicSocial PrufPrediko

Why teams pick ClickHouse Managed Postgres

Real numbers, real production workloads.

Quote icon

ClickHouse Managed Postgres and WALShadow opens up a new way of thinking about databases at Clay

The raw speed of NVMe combined with low latency replication to ClickHouse allows us to build high throughput operational systems with massive scale real time visibility, unlocking experiences for customers that simply weren't possible in the past.

We're currently powering our next generation platform with it at scale, and are looking forward to what comes next!

Clay
Quote icon

One data stack for robotics: transactions on Managed Postgres, analytics on ClickHouse

Before the move, on RDS, finding out whether the robot had seen "air fryer" data meant multi-table joins that took multiple days to run.

This also gave us added benefit where people started building new sorts of applications that they weren't thinking about before, because they have all of their datasets in one place.

Physical Intelligence
Quote icon

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.

Quinto Andar

Key benefits

guage

Run Postgres up to 10x faster, reliably

Local NVMe storage removes the network between compute and storage, supporting more parallel reads and writes with lower latency. High availability, point-in-time recovery, and read replicas are included by default.

lightning

Get sub-second replication into ClickHouse, no pipeline required

WalShadow (private preview) reads directly from the physical WAL and replicates changes into ClickHouse in around 200 ms, without logical replication slots. ClickPipes remains the migration and fallback CDC path.

database

Query transactions and analytics through one interface

pg_clickhouse lets applications use standard Postgres SQL for transactional and analytical queries. It pushes filters, joins, and aggregations down to ClickHouse without a second database driver or query rewrites.

Why ClickHouse Managed Postgres?

NVMe performance

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

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

  • WalShadow (private preview): ~200 ms replication from the physical WAL, no replication slots

  • ClickPipes CDC for initial migrations and as a fallback path

  • 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

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

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

To learn more, read our blog ->->

Get started with ClickHouse Cloud for free

We'll get you started on a 30 day trial and $300 credits to spend at your own pace.

Start with ClickHouse Managed Postgres

Unified data stack

Combine Postgres for transactions with ClickHouse for analytics to deliver best-in-class performance and scalability with minimal operational overhead.

Architectural pattern followed by thousands of companies like GitLab, Cloudflare, Instacart, and LangChain.

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.

WalShadow (private preview) replicates Postgres to ClickHouse straight from the physical WAL, the same stream Postgres uses for its own standbys. There are no logical replication slots and no decoding load on your primary. In our benchmarks, commits showed up in ClickHouse in around 200 ms while sustaining 289K rows/sec. Schema changes (ADD, RENAME and DROP COLUMN), initial load, restart recovery and planned switchovers are all handled.

ClickPipes Postgres CDC remains available for initial migrations and as a fallback path. Replication from Managed Postgres to ClickHouse is free with either.

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.

Everything you need, from day one

Enterprise Postgres

  • Point in time recovery (PITR)
  • Automated backups
  • Read replicas with faster failover
  • Connection pooling
  • Major version upgrades

ClickHouse Integration

  • pg_clickhouse extension
  • WalShadow sub-second replication (private preview)
  • CDC via ClickPipes
  • Query pushdown (JOINs, AGGs)

Developer experience

  • One click-provisioning
  • ClickHouse Cloud console
  • Metrics and monitoring
  • Query Performance Insights
  • API & Terraform support
  • Agent-ready Postgres, with Xata
Start with ClickHouse Managed Postgres