Pg_chdb, fast imports from object storage to Postgres using COPY

About Pg_chdb, fast imports from object storage to Postgres using COPY

The chdb Postgres extension brings fast imports and exports across cloud storage platforms and data formats, powered by the embedded ClickHouse engine.

In the maker’s words

Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial: https://clickhouse.com/blog/extracting-converting-querying-l... "serverless" in the same sense as here: https://www.sqlite.org/serverless.html and also in the more common sense - clickhouse-local can be packaged into AWS Lambda and serve queries on a per-request basis, as here: https://github.com/ClickHouse/ClickHouse/issues/43589

Where people found it

• Hacker NewsShow HN: Pg_chdb, fast imports from object storage to Postgres using COPY4 points0 comments21 days ago
• Hacker NewsWalShadow: Sub-second Postgres replication to ClickHouse from physical WAL63 points10 comments29 days ago
• Hacker Newspg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries65 points7 comments2026-08-11
• Hacker NewsAndy Pavlo joins ClickHouse to establish ClickHouse Labs340 points76 comments2026-08-03
• Hacker NewsInstrumenting my espresso machine with OpenTelemetry21 points10 comments2026-07-30
• Hacker NewsPg_re2: Postgres extension for fast, RE2-powered regular expressions in Postgres16 points1 comments2026-07-14
• Hacker NewsWe scaled PgBouncer to 4x throughput241 points61 comments2026-07-11
• Hacker NewsWAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups132 points21 comments2026-06-27
• Hacker NewsPostgresBench: A Reproducible Benchmark for Postgres Services113 points24 comments2026-06-20
• Hacker NewsTen years of ClickHouse in open source329 points101 comments2026-06-15
• Hacker NewsPostgres FDW: Pushdown is a negotiation18 points2 comments2026-05-14
• Hacker NewsClickHouse Acquires Langfuse17 points0 comments2026-01-16
• Hacker NewsLessons from a year of Postgres CDC in production74 points8 comments2025-12-20
• Hacker NewsPg_ClickHouse: A Postgres extension for querying ClickHouse117 points45 comments2025-12-10
• Hacker News28M Hacker News comments as vector embedding search dataset454 points171 comments2025-11-28