Analytics Without Leaving Postgres
Thursday, September 10 at 13:35–13:40
Cloud Nine
Intermediate
ClickHouse is building a growing ecosystem of PostgreSQL integrations aimed at analytical workloads and high-volume observability. In this lightning talk, I’ll give a quick technical overview of two open-source extensions: pg_clickhouse, which uses FDW pushdown to execute analytical PostgreSQL queries in ClickHouse and pg_stat_ch, which exports raw per-query execution events from PostgreSQL into ClickHouse for external aggregation and analysis. The goal is to provide a concise introduction to the emerging “Postgres + ClickHouse” stack and the technical direction behind it.