pg_duckdb: Ducking awesome analytics in Postgres

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.