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.
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.
Get the full story
Sign up for Headlinne to unlock AI insights, political bias analysis, and your personalized news feed.
Create free accountAlready have an account? Sign in