pg_duckdb: Ducking awesome analytics in Postgres | POSETTE: An Event for Postgres 2025

Video 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: 1. How you can use pg_duckdb to speed up your Postgres queries 2. How pg_duckdb can be so much faster than Postgres for analytics queries 3. 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. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 07:15 What does pg_DuckDB look like? ⏩ 08:08 Differences between Postgres & DuckDB ⏩ 13:10 How does pg_DuckDB work? ⏩ 15:19 3 ways to us pg_Duckdb ⏩ 16:14 DuckDB on Postgres tables ⏩ 18:53 Read from blob storage ⏩ 22:06 Copy data to MotherDuck 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn - https://www.linkedin.com/company/posetteconf/ X – @PosetteConf, https://twitter.com/PosetteConf Mastodon – @posetteconf, https://mastodon.social/@posetteconf Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com _________________________________ #PosetteC