HackerReposA FIELD GUIDE TO OPEN SOURCE
ProSponsor the shelf♧ 0
← Back to top all-time
ClickHouse
pg_clickhouse
C2025–2026
ClickHouse / pg_clickhouse

pg_clickhouse

Interfaces to query ClickHouse databases from PostgreSQL

3Distinct people
6Mentions
0Explicit recommenders
298GitHub stars
REPOSITORY AT A GLANCE

What to know before exploring

What it is

Interfaces to query ClickHouse databases from PostgreSQL

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

No other repository is repeatedly linked in the same discussions.

This week on Hacker News

Nov 9–Nov 16 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/16/2026, 6:28:55 AM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by month6 dated mentions

Observed mentions: 2025-12-10 19:41:06 UTC to 2026-08-19 15:22:34 UTC.

01232025-12-01 00:00:00 UTC to 2026-01-01 00:00:00 UTC (exclusive): 3 mentions; 2 submissions, 1 commentsDec 20252026-01-01 00:00:00 UTC to 2026-02-01 00:00:00 UTC (exclusive): 1 mentions; 1 submissions, 0 comments2026-02-01 00:00:00 UTC to 2026-03-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2026-03-01 00:00:00 UTC to 2026-04-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2026-04-01 00:00:00 UTC to 2026-05-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 commentsApr 20262026-05-01 00:00:00 UTC to 2026-06-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2026-06-01 00:00:00 UTC to 2026-07-01 00:00:00 UTC (exclusive): 0 mentions; 0 submissions, 0 comments2026-07-01 00:00:00 UTC to 2026-08-01 00:00:00 UTC (exclusive): 1 mentions; 0 submissions, 1 comments2026-08-01 00:00:00 UTC to 2026-09-01 00:00:00 UTC (exclusive): 1 mentions; 0 submissions, 1 commentsAug 2026

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges
UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
PeriodStart (UTC)End (exclusive, UTC)MentionsSubmissionsComments
Dec 20252025-12-01 00:00:00 UTC2026-01-01 00:00:00 UTC321
Jan 20262026-01-01 00:00:00 UTC2026-02-01 00:00:00 UTC110
Feb 20262026-02-01 00:00:00 UTC2026-03-01 00:00:00 UTC000
Mar 20262026-03-01 00:00:00 UTC2026-04-01 00:00:00 UTC000
Apr 20262026-04-01 00:00:00 UTC2026-05-01 00:00:00 UTC000
May 20262026-05-01 00:00:00 UTC2026-06-01 00:00:00 UTC000
Jun 20262026-06-01 00:00:00 UTC2026-07-01 00:00:00 UTC000
Jul 20262026-07-01 00:00:00 UTC2026-08-01 00:00:00 UTC101
Aug 20262026-08-01 00:00:00 UTC2026-09-01 00:00:00 UTC101

What Hacker News says

1 sources

Show HN: ClickHouse Managed Postgres

Hello HN, this is Sai and Kaushik from ClickHouse. We are launching a Postgres managed service that is natively integrated with ClickHouse. We built this in partnership with Ubicloud (https://www.ubicloud.com/) What do you get: It offers NVMe-backed Postgres + built-in CDC into ClickHouse + pg_clickhouse so you can keep your app Postgres-first while running analytics in ClickHouse. Try it (Sign up for private preview): https://clickhouse.com/cloud/postgres Live demo: https://www.youtube.com/watch?v=rpBA13nQxAk&t=4s Detailed technical blog: https://clickhouse.com/blog/postgres-managed-by-clickhouse Problem - Scaling limits of Postgres for OLTP and OLAP As companies grow on Postgres, they often start to run into performance limits, both for transactions and analytics. On the OLTP side, things like slow updates and upserts, painful vacuums,
Read the rest
and WAL spikes from long-running transactions are common, usually driven by disk I/O bottlenecks. With fewer I/O constraints, Postgres could handle a lot more. On the analytics side, many limitations come from the fact that Postgres was designed for OLTP and lacks features common in analytical databases, such as vectorized execution and broad ingest format support. As a result, many companies (e.g., GitLab, Ramp, Cloudflare) complement Postgres with ClickHouse to offload analytics, adopting two purpose-built open-source databases. However, adding ClickHouse to a Postgres-based application isn’t straightforward—you typically need to build CDC pipelines, manage backfills and schema changes, and update application code to handle a second database. Solution - NVMe-backed Postgres natively integrated with ClickHouse On the OLTP side, NVMe-based Postgres can dramatically improve performance. By colocating storage with compute, NVMe enables much lower latency and higher IOPS than network-attached storage, speeding up disk-bound operations (up to 10x), including updates, upserts, vacuums, and checkpointing. We’re working on a detailed blog exploring how NVMe reduces WAL fsync, buffer read, and checkpoint overhead, stay tuned! On the OLAP side, the Postgres service offers native CDC to ClickHouse and unified querying via pg_clickhouse. CDC is currently powered by ClickPipes/PeerDB using logical replication, and we’re working to make it faster and simpler with logical replication v2, a new decoding plugin, and a path toward sub-second replication. Every Postgres comes with the pg_clickhouse (https://github.com/ClickHouse/pg_clickhouse) extension, which simplifies adding ClickHouse-powered analytics to a Postgres application. It lets you query ClickHouse directly from Postgres, enabling a single interface for transactions and analytics. pg_clickhouse supports broad analytics query pushdown, with plans to expand this further over time. Who is it for? 1. Companies who are looking for a faster and more scalable Postgres. 2. Companies already using ClickHouse that want a tightly integrated Postgres to offload analytics to ClickHouse, without the operational burden of managing the integration. 3. Companies that are growing rapidly (or expect to) and want a simple yet powerful stack with Postgres on NVMe + ClickHouse. CTA 1. If the above value and vision resonates with you and you want to try it for a use-case, please sign up here and we will give you access within a day or two! https://clickhouse.com/cloud/postgres 2. We’d love to hear your feedback and anything else that comes to mind, it would be super helpful to us as we build this out!
2 points · Open discussion

MAKE YOURSELF AT HOME

A few shortcuts

/
Search the collection
?
Open this guide
Esc
Close dialogs and navigation

Your saved repositories and interests stay in this browser.