DATABASES Signal 134
Introducing chdb Postgres extension: High-performance imports from cloud storage
↗
The chdb Postgres extension uses an embedded ClickHouse engine to provide fast data imports and exports across various cloud storage platforms and data formats.
The extension allows Postgres users to leverage ClickHouse's performance and broad format support directly within their database. It offers faster import speeds and broader format compatibility compared to existing extensions like pg_duckdb and pg_lake. This simplifies moving data between Postgres and cloud storage systems like S3, GCS, and Azure Blob Storage.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
The chdb extension uses an embedded ClickHouse engine to import and export data from cloud storage directly within Postgres.
Benchmarks show chdb imports data significantly faster than pg_duckdb and pg_lake, and supports a wider array of data formats than aws_s3.
Users can interact with the extension via a chdb_query() function or by hooking into the standard Postgres COPY command.
THE CLUSTER