Pg_chdb is a PostgreSQL extension library that enables fast data imports from object storage (S3, GCS, Azure Blob) into Postgres tables using the COPY command and chDB queries. It supports multiple data formats and demonstrates consistent performance that outperforms similar extensions like pg_duckdb and pg_lake by 2-3x for CSV, JSON, and Parquet imports.
A new Postgres extension called chdb leverages ClickHouse's in-process engine to enable fast imports and exports from cloud object storage in multiple data formats. Benchmarks show chdb outperforms competing extensions like pg_duckdb and pg_lake by 2-3x on CSV, JSON, and Parquet imports, while supporting a broader range of formats through ClickHouse's native capabilities.