Pg_duckdb version 1.0 is now available, bringing DuckDB's vectorized analytical engine directly into PostgreSQL as an extension. This integration enables faster analytical queries on PostgreSQL data without requiring separate data warehouses or complex ETL processes. The extension allows querying PostgreSQL tables with DuckDB's performance benefits, accessing external data lake files (Parquet, CSV, JSON), and joining local PostgreSQL data with remote cloud storage files in single queries. Performance improvements show up to 4x speedup with indexes and dramatic improvements for queries that previously timed out. The release includes enhanced MotherDuck integration for serverless analytics scaling.
Table of contents
DuckDB speed in elephant modeAnalytics on PostgreSQL with ducksPostgreSQL as a data lake engineServerless analytics power with MotherDuckGetting started with pg_duckdbSort: