pg_clickhouse v0.10 Pushes Correlated Subqueries to ClickHouse, Cutting a TPC-H Query From 32.7 Seconds to 37 Milliseconds
ClickHouse's pg_clickhouse extension now pushes whole correlated subqueries down to ClickHouse, taking TPC-H pushdown coverage from 12 to 16 of 22 queries.