ClickHouseGülçin Yıldırım Jelínek7 min readintermediate
Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026
Summary
The author recaps two Dutch conferences where they presented ClickHouse‑Postgres extensions and discussed PostgreSQL 19 monitoring enhancements. The post explains how pg_clickhouse provides transparent query push‑down to ClickHouse and how pg_stat_ch streams per‑query metrics, plus new logging defaults and system views in PG 19.
- pg_clickhouse FDW lets you query ClickHouse tables from Postgres; 15 of 22 TPC‑H queries are fully pushed down at scale factor 1.
- pg_stat_ch streams raw query execution events to ClickHouse via a background worker, giving time‑sliced stats and percentiles without back‑pressure.
- PostgreSQL 19 adds default log_lock_waits, new WAL counters, the WAIT FOR command, and system views pg_stat_lock, pg_stat_recovery, pg_stat_autovacuum_scores.
- New monitoring functions include pg_get_multixact_stats and a higher XID wraparound warning threshold (100 M transactions).
Postgres engineers who need scalable analytics or finer‑grained monitoring will benefit from the extensions and the new PG 19 features.
6/10
