What's new in pg_clickhouse v0.10.0: Subqueries, TPC-H Speedups, C Driver, and Aggregates
Summary
pg_clickhouse v0.10.0 brings substantial pushdown enhancements for subqueries and faster TPC-H queries. The release achieves further pushdown coverage (now 16 of 22 TPC-H queries) with notable wins like Q17 dropping from 32.7s to 37ms, and expands driver surfaces, plus improved NOT IN handling and optional built-in function pushdown. It also introduces new surface area APIs, a migration path for older servers, and broader driver and feature improvements.