pg_duckdb in Action: Accelerating Analytics on Azure Database for PostgreSQL | POSETTE 2026
Key Takeaways
Demonstrates pg_duckdb for accelerating analytics on Azure Database for PostgreSQL
Original Description
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,
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: SQL Analytics
View skill →Related Reads
📰
📰
📰
📰
Boosting Startups with Data Science: A Practical Guide to Data-Driven Growth
Medium · Startup
One Lake, Five Patterns: Rethinking the Enterprise Data Foundation
Medium · Data Science
The Python Automation Libraries That Changed How I Build Data Workflows
Medium · Machine Learning
The Python Automation Libraries That Changed How I Build Data Workflows
Medium · Data Science
🎓
Tutor Explanation
DeepCamp AI