# pg\_clickhouse is the fastest Postgres extension on ClickBench

DevFeed: [pg\_clickhouse is the fastest Postgres extension on ClickBench](<https://devfeed.tech/articles/pg-clickhouse-is-the-fastest-postgres-extension-on-clickbench-5486.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/pg_clickhouse-fastest-analytics-for-postgres>)

Author: David Wheeler

Published: 2026-02-18T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [migration](<https://devfeed.tech/topics/migration.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [extension](<https://devfeed.tech/tags/extension.md>), [migration](<https://devfeed.tech/tags/migration.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>)

## AI overview

The article describes pg_clickhouse, a PostgreSQL extension that rewrites analytics queries for execution in ClickHouse while retaining the Postgres interface. It presents ClickBench results claiming performance close to native ClickHouse across 42 queries.

## Source excerpt

The pg_clickhouse extension minimizes the effort required to run typical analytics queries in Postgres by delegating execution to ClickHouse.