18:45Build smarter search without AI: Fuzzy matching for applications | Data Exposed
Microsoft Developer
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
Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
18:45Microsoft Developer
02:01
20:24
01:40
19:55Microsoft Developer
57:29
09:02Allow Google Analytics to measure visits. Your history stays in your browser. Privacy details