pg_clickhouse发布v0.10版本，在查询优化方面取得显著进展。[1]该版本将TPC-H基准测试中完全下推的查询从12个增加到16个，仅剩6个未完成。[1]其中Q17查询性能从32.7秒优化到37毫秒，性能提升约880倍。[1]
此次更新的核心改进包括实现了子查询下推功能，以及修复了ClickHouse与PostgreSQL在NOT IN操作符三值逻辑上的差异。[1]同时，该版本完全重建了基于纯C客户端库的二进制驱动程序。[1]HTTP驱动现已支持Native格式编码，替代原有TSV路径。[1]二进制驱动在INSERT/COPY FROM操作超过64MiB时会自动刷新缓冲。[1]要充分利用相关SQL下推功能，需要ClickHouse版本不低于25.8。[1]
pg_clickhouse has released version 0.10, marking a significant milestone in query optimization through expanded subquery pushdown capabilities [1]. The update increases fully pushed-down TPC-H benchmark queries from 12 to 16 out of 22 total queries, leaving only 6 remaining unoptimized [1]. Performance improvements are substantial, with query Q17 accelerating from 32.7 seconds to 37 milliseconds—approximately an 880-fold speedup [1].
The new release introduces several technical enhancements aimed at improving compatibility and efficiency. A binary driver has been completely rebuilt using a pure C client library [1], while the HTTP driver now supports Native format encoding, replacing the previous TSV pathway [1]. The update addresses a critical logic discrepancy by fixing the three-valued logic differences between ClickHouse and PostgreSQL in NOT IN operations [1]. Users should note that ClickHouse version 25.8 or higher is required to support the relevant SQL pushdown functions [1]. Additionally, the binary driver's INSERT and COPY FROM operations automatically flush buffers when data exceeds 64 MiB [1].