# 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.

**Importance:** 3/5

## Sources

### Technology
- [Hacker News](https://clickhouse.com/blog/pg_clickhouse-whats-new-july-2026) — Tue, 11 Aug 2026 21:54:25 +0000