Postgres managed by ClickHouse is now in beta

Sai SrirampurMay 27, 2026

Source: Clickhouse
Published: May 27, 2026
Added to Yomu: Aug 28, 2026

Summary

ClickHouse Cloud has launched a fully managed Postgres service in beta to combine transactional and analytical workloads within a single platform. Backed by local NVMe storage, the service provides up to ten times faster transactional performance alongside native change data capture into ClickHouse. Developers can query across both transactional and analytical layers using the pg_clickhouse extension without managing custom data pipelines. The platform also offers managed migration workflows via ClickPipes, database branching, point-in-time recovery, high availability with up to two standbys, and support for over ninety PostgreSQL extensions. More than fifty virtual machine configurations are available, ranging from single vCPU instances to clusters with ninety-six vCPUs and sixty terabytes of NVMe storage.

Context

AI-native and real-time applications require combining transactional OLTP databases with analytical OLAP databases, but stitching Postgres and ClickHouse together through external pipelines and custom application logic introduces operational complexity.

Approach / What changed

ClickHouse introduced a managed Postgres service backed by local NVMe storage integrated directly into ClickHouse Cloud. The service incorporates native change data capture via ClickPipes, unified querying via the pg_clickhouse extension, managed migration workflows, high availability, point-in-time recovery, and compatibility with over 90 extensions.

Takeaways

Postgres managed by ClickHouse runs on local NVMe storage with configurations ranging from 1 vCPU, 8 GB RAM, and 59 GB NVMe up to 96 vCPUs, 768 GB RAM, and 60 TB NVMe.
The service provides native CDC through ClickPipes and a unified query layer via the pg_clickhouse extension at no additional cost.
The platform includes high availability with up to two standbys, point-in-time recovery, database branching, read replicas, and more than 90 PostgreSQL extensions.

Architecture Data Pipelines Migrations Performance Postgres

Read original post

Postgres managed by ClickHouse is now in beta

Sai SrirampurMay 27, 2026

Source: Clickhouse
Published: May 27, 2026
Added to Yomu: Aug 28, 2026

Summary

Context

Approach / What changed

Takeaways

Postgres managed by ClickHouse runs on local NVMe storage with configurations ranging from 1 vCPU, 8 GB RAM, and 59 GB NVMe up to 96 vCPUs, 768 GB RAM, and 60 TB NVMe.
The service provides native CDC through ClickPipes and a unified query layer via the pg_clickhouse extension at no additional cost.
The platform includes high availability with up to two standbys, point-in-time recovery, database branching, read replicas, and more than 90 PostgreSQL extensions.

Architecture Data Pipelines Migrations Performance Postgres

Read original post

Related reading

Clickhouse · Mar 17, 2026
AI is redrawing the database market
Emerging artificial intelligence workloads are fundamentally transforming data platform requirements across real-time analytics, data warehousing, and observability. Conversational analytics and autonomous agents replace periodic batch queries with rapid bursts of concurrent, low-latency requests, exposing the architectural limits of traditional cloud data warehouses and standalone transactional databases. To resolve these constraints, architectures are converging on engine-level integrations between Postgres for transactions and ClickHouse for analytical scale, while unifying operational observability and business event storage. ClickHouse also incorporates turnkey agent interfaces through its acquisition of LibreChat alongside dedicated execution tracing from tools like Langfuse. These combined capabilities ensure organizations can reliably support interactive agentic workflows without incurring severe latency penalties or compounding infrastructure costs.
Tanya Bragin
Clickhouse · Mar 19, 2026
March 2026 newsletter
The March 2026 ClickHouse newsletter details major platform updates, community deployments, and architectural practices for high-throughput analytics. Recent product announcements include ClickHouse 26.2 featuring time-based block flushing for streaming feeds, general availability of native inverted indexes for full-text search, and the release of chDB 4 with a Pandas-compatible DataStore API. Community implementations show Cloudflare managing 1.61 quadrillion daily events, while Trigger.dev isolated multi-tenant SQL execution using a domain-specific query language that compiles safe ClickHouse queries. In data optimization techniques, Hookdeck accelerated webhook payload search from over 30 seconds to under 400 milliseconds by partitioning payload hashes into typed bucket columns and scanning iterative time windows. Additional operational guidance emphasizes setting the ttl_only_drop_parts parameter and aligning table partitioning with time units so background merges drop entire data parts cleanly without triggering mutation rewrites.
Mark Needham
Clickhouse · Mar 17, 2026
How Socialpruf built a faster, more reliable data stack by replacing Neon with Postgres managed by ClickHouse
Socialpruf, a social media performance tracking platform ingesting hundreds of posts per second, experienced analytics latency, connection dropouts, and high network transfer costs while running Postgres on Neon alongside ClickHouse Cloud. To resolve these issues, the team migrated their transactional system of record to NVMe-backed Postgres managed by ClickHouse, colocating transactional and analytical workloads. Although standard Postgres logical replication failed on their 0.5 TB dataset, they achieved continuous synchronization using PeerDB before conducting a production cutover. The migration eliminated connection dropouts, reduced network transfer fees, and improved overall Postgres query performance by approximately 30 percent. To manage thousands of concurrent connections generated by ingestion workers, Socialpruf implemented ClickHouse's bundled, horizontally scalable PgBouncer instances.
ClickHouse
Clickhouse · Mar 27, 2026
How we’re building a data platform for a new user: agents
AI agents are emerging as autonomous database users that generate SQL, execute queries, and iterate in seconds. Because traditional analytics workflows built for human analysts cannot keep up with these rapid loops, ClickHouse is adapting its platform for agentic workloads. The proposed Agentic Data Stack combines LibreChat for conversational interfaces, ClickHouse with Model Context Protocol servers for the data layer, and Langfuse for observability. Supporting developer tooling includes chDB 4 with a Pandas-like API, IDE integrations, and ClickHouse Agent Skills to enforce database design best practices. Platforms like Anthropic and Character.AI already leverage ClickHouse's high-concurrency aggregation and real-time ingestion capabilities to handle massive data scales required by modern AI applications.
Al Brown