pg_duckdb: Ducking awesome analytics in Postgres
2025/06/12Video of a conference talk highlighting pg_duckdb, a new open-source Postgres extension that makes it easy and fast to run analytics queries straight from within Postgres. You can often use pg_duckdb to speed up your slowest Postgres queries significantly without having to make any changes to your query, data or schema! And if you want to speed up your queries even more, that's possible too. pg_duckdb makes it very easy to store some of your data remotely in columnar format in S3, Azure blob storage, MotherDuck and more.
In this talk you'll learn:
-
How you can use pg_duckdb to speed up your Postgres queries
-
How pg_duckdb can be so much faster than Postgres for analytics queries
-
How you can utilize remote columnar data storage to make your queries even faster
Jelte Fennema-Nio currently works at MotherDuck, a DuckDB-as-a-Service company. He spends most of his time there working on pg_duckdb. Before that, Jelte worked for 5 years at Microsoft on Citus, Postgres and Pgbouncer, and is still one of the maintainers of the PgBouncer project. He studied at the University of Amsterdam where he got his BSc in Computer Science and MSc in System and Network Engineering.
Related Videos

20:44
2025-06-13
What can Postgres learn from DuckDB? (PGConf.dev 2025)
DuckDB an open source SQL analytics engine that is quickly growing in popularity. This begs the question: What can Postgres learn from DuckDB?
YouTube
Ecosystem
Talk

2025-06-02
Taming file zoos: Data science with DuckDB database files
Tame "file zoos" with DuckDB! This talk reveals how DuckDB seamlessly integrates with Python to read/write diverse files (CSV, Parquet), organize data efficiently, enable larger-than-memory analysis, and streamline your workflows.
Python
Talk

2025-04-23
Instant SQL Mode - Real Time Feedback to Make SQL Data Exploration Fly
Hamilton Ulmer shares insights from MotherDuck's Instant SQL Mode, exploring how real-time query result previews eliminate the traditional write-run-debug cycle through client-side parsing and DuckDB-WASM caching.
SQL
Talk
MotherDuck Features