pg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries
saisrirampur
49 points
4 comments
August 11, 2026
Related Discussions
Found 5 related stories in 205.1ms across 8,687 title embeddings via pgvector HNSW
- We scaled PgBouncer to 4x throughput saisrirampur · 194 pts · July 11, 2026 · 62% similar
- Pgrust v0.2: Now faster than Postgres and Clickhouse Latest malisper · 18 pts · July 30, 2026 · 57% similar
- Show HN: WaveHouse – Supabase for ClickHouse ericandr · 15 pts · August 20, 2026 · 52% similar
- Pg_re2: Postgres extension for fast, RE2-powered regular expressions in Postgres saisrirampur · 16 pts · July 14, 2026 · 51% similar
- Pgbot: A 5.9 MB read-only Postgres tool for humans and agents sashash · 47 pts · August 25, 2026 · 48% similar
Discussion Highlights (2 comments)
manbash
> December's headline feature was teaching the planner to push a whole correlated EXISTS subquery down as a single LEFT SEMI JOIN instead of a nested loop with one ClickHouse round trip per outer row. This moved the needle from 3 of 22 TPC-H queries all the way to 12. LLMs sure love throwing in archaic expressions such as "move the needle". The abrupt contrast in jargons is so unpleasant and keeps throwing me off right in the middle of reading.
manjose2018
Please consider comparing pg_clickhouse to pgrust. https://malisper.me/how-we-made-postgres-hundreds-of-times-f...