---
title: "🗽 Postgres Summit US 2026 retrospective"
description: "ClickHouse sponsored Postgres Summit US 2026 in New York City, where David Wheeler presented “Postgres in da ClickHouse” on integrating Postgres and ClickHouse for OLTP and OLAP workloads. He demoed four technologies: pg_stat_ch for query metrics, pg_clickhouse for querying ClickHouse from Postgres (pushing down 16 of 22 TPC-H queries and supporting nearly all Postgres data types), chdb_hook for efficient data lake file import/export via COPY (outperforming similar extensions), and WalShadow for sub-second physical replication. Other sessions covered pg_plan_advice in Postgres 19, index prefetching for Postgres 20, open source CDC plugins, and a graveyard of technologies that failed to “kill” SQL. Wheeler also attended talks on Postgres replication, African Postgres communities, and CloudNativePG extensions. The conference marked ClickHouse’s first Postgres conference sponsorship, with plans to sponsor PGConf.EU in Valencia."
---

# 🗽 Postgres Summit US 2026 retrospective

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

**Type:** Announcement

## Summary

ClickHouse sponsored Postgres Summit US 2026 in New York City, where David Wheeler presented “Postgres in da ClickHouse” on integrating Postgres and ClickHouse for OLTP and OLAP workloads. He demoed four technologies: pg\_stat\_ch for query metrics, pg\_clickhouse for querying ClickHouse from Postgres (pushing down 16 of 22 TPC-H queries and supporting nearly all Postgres data types), chdb\_hook for efficient data lake file import/export via COPY (outperforming similar extensions), and WalShadow for sub-second physical replication. Other sessions covered pg\_plan\_advice in Postgres 19, index prefetching for Postgres 20, open source CDC plugins, and a graveyard of technologies that failed to “kill” SQL. Wheeler also attended talks on Postgres replication, African Postgres communities, and CloudNativePG extensions. The conference marked ClickHouse’s first Postgres conference sponsorship, with plans to sponsor PGConf.EU in Valencia.

## Context

A personal retrospective from a ClickHouse employee about their experience at Postgres Summit US 2026, focusing on their talk on Postgres-ClickHouse integration and highlights of other sessions.

## Takeaways

- ClickHouse offers four technologies for Postgres integration: pg\_stat\_ch for metrics, pg\_clickhouse for cross-database queries, chdb\_hook for data lake file import/export, and WalShadow for sub-second replication.
- Postgres 19 will include pg\_plan\_advice to influence query planning without SQL hints, and Postgres 20 is expected to add index prefetching for improved index scan performance via parallel asynchronous I/O.
- The Postgres ecosystem continues to absorb technologies once seen as SQL ‘killers,’ such as NoSQL, scaling solutions, and vector search, now implemented as Postgres features or extensions.

## FAQ

### What technologies does ClickHouse offer for Postgres integration?

ClickHouse offers pg\_stat\_ch for query metrics, pg\_clickhouse for querying ClickHouse from Postgres, chdb\_hook for data lake file import/export via COPY, and WalShadow for sub-second physical replication from Postgres to ClickHouse.

### What new Postgres features were discussed at the summit?

Postgres committer Robert Haas introduced pg\_plan\_advice for Postgres 19 to influence query planning without SQL hints. Peter Geoghegan presented index prefetching for Postgres 20, which improves index scan performance via parallel asynchronous I/O.

### What is the Postgres Ecosystem Foundation session?

David Wheeler is co-organizing a half-day session at PGConf.EU in November to strategize ways to address challenges in maintaining open-source extensions and ecosystem tools across vendors and providers.

**Tags:** [ClickHouse](https://yomu.fyi/topic/clickhouse), [Community](https://yomu.fyi/topic/community), [Conference](https://yomu.fyi/topic/conference), [Integration](https://yomu.fyi/topic/integration), [Postgres](https://yomu.fyi/topic/postgres)

- Source: [Clickhouse](https://clickhouse.com/blog/postgres-summit-us-2026)
- Source URL: https://clickhouse.com/blog/postgres-summit-us-2026
- Ingested by Yomu: 2026-10-07T18:00:12.639Z

[Read original post](https://clickhouse.com/blog/postgres-summit-us-2026)