Show HN: Pg_chdb, fast imports from object storage to Postgres using COPY

Category: database

Tags: postgres, clickhouse, data-import, cloud-storage, etl

Score: 7.3/10 (Innovation: 7, Technical: 8, Documentation: 8, Utility: 7)

Pg_chdb is a Postgres extension that integrates the chDB (in-process ClickHouse) library to enable high-performance imports and exports from cloud object storage via the COPY command. It stands out for its innovative architecture that runs chDB in a separate helper process, avoiding resource bloat and providing broad format support, making it a powerful tool for data loading.

Target audience: data engineers, backend developers, devops

Repository: https://clickhouse.com/blog/introducing-chdb-postgres

View on Hacker News