pg_duckdb in Action: Accelerating Analytics on Azure Database for PostgreSQL

on YouTube ↗24m

" summary

pg_duckdb embeds DuckDB 1.4.3 inside Azure Database for PostgreSQL Flexible Server and converts eligible SELECT plans to DuckDB’s vectorized engine, claiming 2.4x speed on TPC‑H Q1 (26.6s → 11.1s) and ~7x on a multi‑count aggregation (15.7s → 2.3s). Demo shows direct Parquet read/write to Azure Blob Storage, joins between live Postgres tables and blob Parquet files, and a transparent fallback when the extension can’t handle a query. pg_duckdb duckdb.force_execution Parquet on Azure Blob

AI-written summary · about

" chapters (11)

1. 0:00Music & introduction
2. 1:39What is pg_duckdb?
3. 2:14PostgreSQL strengths and workload types
4. 3:30Differences between OLTP and OLAP
5. 4:38PostgreSQL’s limitations for analytics
6. 6:28DuckDB overview and key advantages
7. 10:12How PostgreSQL processes queries
8. 13:08pg_duckdb capabilities in acceleration, Azure blobs, & hybrid analytics
9. 15:27Demo: faster query performance
10. 20:00Querying Parquet and hybrid analytics
11. 22:55Key takeaways and closing summary

" related talks

• 24mpg_duckdb: Ducking awesome analytics in PostgresJelte Fennema-Nio · POSETTE: An Event for Postgres 2025
• 21mWhat can Postgres learn from DuckDB?Jelte Fennema-Nio · PGConf.dev 2025
• 40mDuckDB: Harnessing in-process analytics for data science and beyondGabor Szarnyas · Øredev 2023
• 25mWhat’s New with Azure Database for PostgreSQL- Flexible ServerVARUN DHAWAN · POSETTE: An Event for Postgres 2025
• 03mpg_duckdb: DuckDB-powered PostgresJonathan Dance · DuckCon #5 (Seattle, 2024)
• 01h 02mAnalytics for not-so-big data with DuckDBDavid Ostrovsky · NDC Oslo 2025
• 34mData Wrangling with DuckDBWill Angel · PyData Virginia 2025
• 26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible ServerKanchan Bharati · POSETTE: An Event for Postgres 2024