Menu

Post image 1
Post image 2
Post image 3
Post image 4
Post image 5
Post image 6
Post image 7
1 / 7
65

What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates | ClickHouse

Hacker News·about 1 month ago
#gDv3jUfX
#clickhouse#null#down#query#foreign#article
Reading 0:00
15s threshold

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. Along the way, we also rebuilt the binary driver on a new plain-C client library, more than doubled the surface area of functions and aggregates that push down, hardened the binary driver against a couple of concurrency bugs, detailed below. Three more TPC-H queries now fully push down.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More