---
title: "Postgres at Open House NYC"
description: "At ClickHouse Open House NYC, the team announced WalShadow, an open-source engine that replicates Postgres into ClickHouse from the physical WAL, achieving sub-second latency and high throughput. They also launched ClickHouse Managed Postgres on Google Cloud in private preview, offering Postgres on local NVMe storage with native CDC into ClickHouse. The chdb Postgres extension was released, enabling fast imports from cloud storage using the embeddable ClickHouse engine. A live demo showed WalShadow keeping ClickHouse under 400 ms behind during a simulated trading platform with 50,000 trades per second, and detecting a fraud burst in under 500 ms compared to over 15 seconds with ClickPipes. The integrated stack aims to provide world-class Postgres for transactions and ClickHouse for analytics, with WalShadow as a key step toward unifying OLTP and OLAP."
---

# Postgres at Open House NYC

[Clickhouse](https://yomu.fyi/company/clickhouse) · Oct 13, 2026

**Type:** Announcement

## Summary

At ClickHouse Open House NYC, the team announced WalShadow, an open-source engine that replicates Postgres into ClickHouse from the physical WAL, achieving sub-second latency and high throughput. They also launched ClickHouse Managed Postgres on Google Cloud in private preview, offering Postgres on local NVMe storage with native CDC into ClickHouse. The chdb Postgres extension was released, enabling fast imports from cloud storage using the embeddable ClickHouse engine. A live demo showed WalShadow keeping ClickHouse under 400 ms behind during a simulated trading platform with 50,000 trades per second, and detecting a fraud burst in under 500 ms compared to over 15 seconds with ClickPipes. The integrated stack aims to provide world-class Postgres for transactions and ClickHouse for analytics, with WalShadow as a key step toward unifying OLTP and OLAP.

## Context

ClickHouse’s Open House NYC event where the team presented new Postgres integration capabilities, including WalShadow, Managed Postgres on GCP, and the chdb extension.

## Approach / What changed

WalShadow replicates Postgres into ClickHouse by decoding the physical WAL outside the source database, building ClickHouse-native blocks, and inserting them in parallel, using a schema-only shadow Postgres instance to track catalog changes.

## Takeaways

- WalShadow achieves sub-second replication latency (around 200 ms) and high throughput (around 300,000 rows per second) on modest 8-vCPU instances, compared to PeerDB’s ~10 seconds and ~120,000 rows per second.
- ClickHouse Managed Postgres on Google Cloud is now in private preview, offering Postgres on GCP Local SSD with native CDC into ClickHouse Cloud via in-region ClickPipes, and includes the pg\_clickhouse extension.
- The chdb Postgres extension enables fast imports from cloud storage (S3, GCS, Azure Blob, etc.) using the embeddable ClickHouse engine, and in benchmarks it was more consistent than DuckDB-based extensions for CSV, JSON, and Parquet imports.

## FAQ

### How does WalShadow differ from logical replication?

WalShadow decodes the physical WAL outside the source, avoiding the need for a logical replication slot on the primary. It achieves lower latency (around 200 ms) and higher throughput (300,000 rows/s) compared to logical replication-based tools like PeerDB, which had ~10 seconds and 120,000 rows/s.

### What is the chdb Postgres extension and how does it work?

The chdb extension provides a chdb\_query() function and a chdb\_hook module that extends COPY to read/write from cloud storage. It runs the ClickHouse engine in a short-lived helper process, so it only uses resources while a command is running.

### When will ClickHouse Managed Postgres be available on Google Cloud?

ClickHouse Managed Postgres on Google Cloud is in private preview now. Users can join the waitlist. It offers Postgres on GCP Local SSD, native CDC into ClickHouse Cloud via in-region ClickPipes, and the pg\_clickhouse extension.

**Tags:** [CDC](https://yomu.fyi/topic/cdc), [ClickHouse](https://yomu.fyi/topic/clickhouse), [Managed Postgres](https://yomu.fyi/topic/managed-postgres), [Postgres](https://yomu.fyi/topic/postgres)

- Source: [Clickhouse](https://clickhouse.com/blog/postgres-at-open-house-nyc)
- Source URL: https://clickhouse.com/blog/postgres-at-open-house-nyc
- Ingested by Yomu: 2026-10-13T18:00:12.431Z

[Read original post](https://clickhouse.com/blog/postgres-at-open-house-nyc)