pg_clickhouse is the fastest Postgres extension on ClickBench

In December 2025, the PostgreSQL extension pg_clickhouse was launched to facilitate seamless querying of ClickHouse directly from Postgres, aimed at reducing the migration effort for analytics workloads from Postgres to ClickHouse. By offloading analytic execution to ClickHouse, pg_clickhouse minimizes the load on Postgres, allowing for independent scaling and avoiding resource contention, particularly beneficial for aggregation-heavy queries. The extension is evaluated using ClickBench, where it demonstrated superior performance among PostgreSQL extensions, closely matching the speed of native ClickHouse. This performance is achieved through effective query pushdown, which handles a wide range of operations, and the extension continues to evolve with plans to support more complex queries. Pg_clickhouse is available as an open-source option and within the managed Postgres service in ClickHouse Cloud, marking a strategic choice for scalable applications.