Skip to content
Download full logoDownload logomark

Postgres managed by ClickHouse

快速、可扩展、企业级的 Postgres，与 ClickHouse 原生集成。

为实时与 AI 驱动的应用而构建。

统一的数据栈,使用 Postgres 处理事务、ClickHouse 处理分析，不增加额外的复杂度！

开始免费试用了解更多
Postgres Dashboard

深受用户信赖

Quinto AndarDo ControlSterling LabsTrainyDavid AIMpathicSocial PrufPrediko
Quinto AndarDo ControlSterling LabsTrainyDavid AIMpathicSocial PrufPrediko

为什么选择 Postgres managed by ClickHouse？

NVMe 级性能

运行在 本地 NVMe 存储 上的企业级 Postgres。微秒级延迟、近乎无限的 IOPS，以及不受网络抖动影响的稳定性能。

  • 在 I/O 密集型工作负载下性能最高提升 10 倍

  • 极低的磁盘延迟：微秒级 vs 毫秒级

  • 无 EBS 限流或上限约束

  • 架构经过 Datadog、Instacart 验证

ClickHouse 集成

Postgres 邂逅 ClickHouse，实时分析提速 100 倍。事务与分析工作负载一体化。

  • 原生 CDC：只需几次点击，即可将 Postgres 数据同步到 ClickHouse。

  • 秒级延迟的极速复制

  • pg_clickhouse:统一查询层,支撑同时承载事务与分析的应用。

  • 通过 pg_clickhouse 实现全面的查询下推 —— 包括 JOIN、聚合等。

与 Ubicloud 共同打造的企业级 Postgres

为关键业务负载而生的 Postgres。可用性、可靠性、安全性以及标准托管服务能力，绝不妥协。与 Ubicloud 的资深 Postgres 专家共同打造。

  • 最多 2 个 Standby 实现高可用

  • 自动备份与 WAL 归档至 S3

  • Fork 与时间点恢复(PITR)

  • 端到端加密与私有网络

  • 由 ClickHouse Cloud Trust 提供保障

开源优先

基于开源原则构建。每个组件都开源，没有厂商锁定，数据栈完全掌握在您手中。

如需了解更多,请 阅读我们的博客 ->->

团队为何选择 Postgres managed by ClickHouse

真实的数字，真实的生产工作负载。

Quote icon

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.

Sterling Labs
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
Quote icon

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.

Do Control

统一的数据栈

将处理事务的 Postgres 与处理分析的 ClickHouse 相结合，以最小的运维成本带来业界领先的性能与可扩展性。

这是 GitLab、Cloudflare、Instacart、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.

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.

从第一天起，您所需的一切均已就位

企业级 Postgres

  • 时间点恢复(PITR)
  • 自动备份
  • 具备更快故障切换的只读副本
  • 连接池
  • 主版本升级

ClickHouse 集成

  • pg_clickhouse 扩展
  • 通过 ClickPipes 实现 CDC
  • 查询下推（JOIN、聚合）
  • Logical Replication v2即将推出
  • 自定义输出插件即将推出

开发者体验

  • 一键开通
  • ClickHouse Cloud 控制台
  • 指标与监控
  • 查询性能洞察
  • API 与 Terraform 支持即将推出
在 ClickHouse Cloud 上试用 Postgres