pg_duckdb beta release : Even faster analytics in Postgres
In August, we announced the pg_duckdb extension, a collaborative open-source project with Hydra, DuckDB Labs, and MotherDuck. pg_duckdb is a PostgreSQL extension that integrates DuckDB's analytics engine directly into PostgreSQL, allowing for rapid analytical queries alongside traditional transactional workloads.
Two months later, we are happy to share a beta release of the extension, which includes some exciting features like using DuckDB engine to query PostgreSQL data, querying object storage data and much more.
The easiest way to get started is to use the Docker image provided, which includes PostgreSQL with the latest build of the pg_duckdb extension pre-installed.
When initializing PostgreSQL, a superuser password must be set. For the sake of demonstration here, we’ve allowed all connections without a password using POSTGRES_HOST_AUTH_METHOD. This is not recommended for production usage.
PostgreSQL is a transactional database, not an analytical one. It is well-suited for lookups, small updates, and running queries when you have carefully set up your indexes and join relationships. It isn’t, however, great when you want to run ad-hoc analytical queries across the full dataset.
