# pg_clickhouse

7 Hacker News commenters recommended pg_clickhouse and 0 criticized it, November 2025 to November 2026. It was recommended in 5 of 13 months.

**Verdict:** People recommend it as a Postgres extension that runs analytical queries and joins against ClickHouse while keeping OLTP queries in Postgres, with strong subquery pushdown.

## Why people recommend it

- Pushes subqueries and joins to ClickHouse (3 comments): "Correctly pushing subqueries while preserving the semantics of the original database is something I can't imagine I could've ever achieved" ([source](https://news.ycombinator.com/item?id=49268941)) "It lets you run OLTP and OLAP queries from Postgres, while pushing the analytical queries—and their joins—down to ClickHouse" ([source](https://news.ycombinator.com/item?id=46260223)) "Our main focus is comprehensive pushdown capabilities." ([source](https://news.ycombinator.com/item?id=46249462))
- Unified OLTP and OLAP query layer (2 comments): "It lets you run OLTP and OLAP queries from Postgres, while pushing the analytical queries—and their joins—down to ClickHouse" ([source](https://news.ycombinator.com/item?id=46260223)) "since you'll be using a unified query layer for your application" ([source](https://news.ycombinator.com/item?id=46249780))

## Alternatives hackers recommend

- [pgvector](https://hackerapproved.com/p/pgvector.md): 55 recommend
- [PostGIS](https://hackerapproved.com/p/postgis.md): 20 recommend
- [pg_lake](https://hackerapproved.com/p/pg-lake.md): 18 recommend
- [ParadeDB](https://hackerapproved.com/p/paradedb.md): 13 recommend
- [pg_textsearch](https://hackerapproved.com/p/pg-textsearch.md): 10 recommend

## Cite as

Hacker Approved, "pg_clickhouse", https://hackerapproved.com/p/pg-clickhouse/ (counts from 1,795,640 Hacker News comments, November 2025 to November 2026).