Skip to content
Download full logoDownload logomark

ClickHouse Managed Postgres

将 Postgres 的运行速度提升至多 10 倍，并与 ClickHouse 原生集成。

开始使用 ClickHouse Managed Postgres
使用 Google 注册
查看文档

ClickHouse Managed Postgres 与 ClickHouse 运行在同一个平台上，将 Postgres 的运行速度提升至多 10 倍，并通过 WalShadow（私有预览）实现亚秒级复制和统一的查询接口。

Xata

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

AWS已上线
Google Cloud私有预览
Azure规划中
Postgres Dashboard

深受用户信赖

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

团队为何选择 ClickHouse Managed Postgres

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

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

主要优势

guage

将 Postgres 的运行速度可靠地提升至多 10 倍

本地 NVMe 存储消除了计算与存储之间的网络开销，支持更多并行读写并降低延迟。高可用性、时间点恢复和读副本均默认提供。

lightning

无需管道，即可实现到 ClickHouse 的亚秒级复制

WalShadow（私有预览）直接从物理 WAL 读取数据，并在约 200 毫秒内将变更复制到 ClickHouse，无需使用逻辑复制槽。ClickPipes 仍是迁移和备用 CDC 的路径。

database

通过统一接口查询事务与分析数据

pg_clickhouse 让应用程序可以使用标准的 Postgres SQL 进行事务和分析查询，将过滤、连接和聚合操作下推到 ClickHouse，无需第二个数据库驱动或重写查询。

为什么选择 ClickHouse Managed Postgres？

NVMe 级性能

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

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

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

  • 无 EBS 限流或上限约束

  • 架构经过 Datadog、Instacart 验证

ClickHouse 集成

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

  • WalShadow（私有预览）：从物理 WAL 实现约 200 毫秒的复制，无需复制槽

  • ClickPipes CDC 用于初始迁移及作为备用路径

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

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

与 Ubicloud 共同打造的企业级 Postgres

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

  • 最多 2 个 Standby 实现高可用

  • 自动备份与 WAL 归档至 S3

  • Fork 与时间点恢复(PITR)

  • 端到端加密与私有网络

  • 由 ClickHouse Cloud Trust 提供保障

开源优先

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

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

免费开始使用 ClickHouse Cloud

我们将为您提供 30 天试用期及 300 美元额度，助您自如开启探索。

开始使用 ClickHouse Managed Postgres

统一的数据栈

将处理事务的 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.

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.

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

企业级 Postgres

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

ClickHouse 集成

  • pg_clickhouse 扩展
  • WalShadow 亚秒级复制（私有预览）
  • 通过 ClickPipes 实现 CDC
  • 查询下推（JOIN、聚合）

开发者体验

  • 一键开通
  • ClickHouse Cloud 控制台
  • 指标与监控
  • 查询性能洞察
  • API 与 Terraform 支持
  • 与 Xata 协作，具备智能体能力的 Postgres
开始使用 ClickHouse Managed Postgres