Author: Microsoft Developer - Bewertung: 2x - Views:16351
See how pg_duckdb enables analytics directly in Postgres. Nitin Jadhav (Microsoft) demonstrates this in his talk “pg_duckdb in Action: Accelerating Analytics on Azure Database for PostgreSQL” at POSETTE: An Event for Postgres 2026. Abstract: If your analytics workflow starts with exporting data from Postgres, you’re not alone. Many teams build ETL pipelines just to answer questions about data that already lives in Postgres. But what if you didn’t have to move it at all? With pg_duckdb, you can run fast, columnar-style analytical queries inside Postgres without setting up a separate warehouse, a sync process, or another system to manage.
In this talk, I’ll walk through how pg_duckdb works, what it’s good at, and where it fits into real-world workflows. The demo will showcase pg_duckdb installed on Azure Database for PostgreSQL, where I’ll run analytical queries over existing tables and query Parquet files directly from object storage—without loading them into Postgres first.
It’s not a full replacement for a data warehouse, but in many cases, it’s a faster, simpler path to the answers your team needs—right from the database you already use. Attendees will learn how pg_duckdb works, how to use it effectively, and how to speed up analytics without extra tools or data movement. You’ll leave with practical tips and real examples you can apply right away.
Nitin Jadhav is a Senior Software Engineer with extensive experience in database systems. Currently working at Microsoft, he has been part of the Azure Database for PostgreSQL team for the past few years. His contributions include onboarding new major and minor versions of PostgreSQL and integrating extensions into the managed database. Additionally, Nitin has been involved in handling customer issues, analyzing and resolving various database corruption problems, and contributing to the PostgreSQL community as needed. Before joining Microsoft, Nitin worked at EDB, where he began hacking into PostgreSQL. Prior to EDB, he was part of Toshiba, working on SQLite internals.
► Video chapters:
⏩ 00:00 – Music & introduction
⏩ 01:39 – What is pg_duckdb?
⏩ 02:14 – PostgreSQL strengths and workload types
⏩ 03:30 – Differences between OLTP and OLAP
⏩ 04:38 – PostgreSQL’s limitations for analytics
⏩ 06:28 – DuckDB overview and key advantages
⏩ 10:12 – How PostgreSQL processes queries
⏩ 13:08 – pg_duckdb capabilities in acceleration, Azure blobs, & hybrid analytics
⏩ 15:27 – Demo: faster query performance
⏩ 20:00 – Querying Parquet and hybrid analytics
⏩ 22:55 – Key takeaways and closing summary
📕 Everything you need to know about POSETTE: An Event for Postgres 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://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
Microsoft for Postgres LinkedIn: https://www.linkedin.com/company/microsoft-for-postgresql
#PosetteConf #PostgreSQL #Azure
SOCIAL SHARE CARD GENERATOR