pg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries
The pg_clickhouse project released version 0.10, which introduces subquery pushdown optimizations for the TPC-H benchmark suite. These improvements allow the system to execute complex analytical queries up to 1000x faster by offloading processing to ClickHouse.
Why it matters
This update demonstrates significant performance gains for PostgreSQL users handling large-scale analytical workloads, bridging the gap between relational databases and specialized OLAP engines.
Continuing our investment in pg_clickhouse, improving pushdown coverage for analytic workloads has remained our top focus, with full pushdown across the TPC-H benchmark suite as our immediate metric. We've had a lot of progress since our last update in June , including on the TPC-H scoreboard, which we haven't really talked about since our introductory post back in December, so that's where we'll start. With the release of v0.10.0, our scoreboard has moved from 12 of 22 TPC-H queries fully pushed down to 16, leaving only 6 to go to finish off the set.
Three more TPC-H queries now fully push down. All three were exceedingly inefficient before because, due to the shape of the query, pg_clickhouse had to fetch every row from ClickHouse individually and then evaluate the subquery on it locally ( full chart ):
Get smarter about the news
Sign up free for a feed built around what you actually care about, Dive Deeper research on any story, and the full text of every article.
Create free accountAlready have an account? Sign in