Loading post…
ClickhouseAnnouncement
🗽 Postgres Summit US 2026 retrospective
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.
Source and freshness
- Source
- clickhouse.com
- Published
- Added to Yomu
Summaries are generated from the original by a language model. Check the original before relying on it.
Keep reading
Related reading
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
The best engineering reads, once a week
One useful email. Unsubscribe anytime.