pg_clickhouse v0.10 adds subquery pushdown, speeds TPC-H queries 1000x

pg_clickhouse, a PostgreSQL extension for querying ClickHouse, released v0.10 with subquery pushdown support. This optimization yields up to 1000x faster TPC-H benchmark queries. It significantly improves analytical performance for workloads spanning both databases.

Sources (1)