ClickHouse's pg_clickhouse v0.10 cuts TPC-H Q17 runtime 884x
The extension keeps PostgreSQL as the SQL interface while moving eligible analytical subqueries into ClickHouse for execution.
By Ryan Merket · Published
Primary source: ClickHouse
Why it matters
ClickHouse is using pg_clickhouse to make its analytical engine adoptable without a wholesale PostgreSQL migration. The 884x Q17 result shows the payoff when pushdown works, while the remaining query gaps define the engineering risk.

The extension keeps PostgreSQL as the SQL interface while moving eligible analytical subqueries into ClickHouse for execution.
When you purchase through links in our articles, we may earn a small commission. This doesn’t affect our editorial independence.