Key PostgreSQL Query Tuning foundation Every Database Developer Should Build
Presented by:
Deepak Mahto
I am Deepak Mahto, with 17+ years of experience enjoying the challenge of solving complex database problems. I like to call myself your "Database Guy" with expertise in PostgreSQL and Migration from Oracle or SQL Server. Currently, I am the Founder of DataCloudGaze Consulting, where I help customers and partners succeed with migration to PostgreSQL.
Previously, I worked at Google Cloud and Amazon Web Services, assisting over 17+ Enterprise Customers in migrating from legacy commercial databases and facilitating the conversion of over 1 million lines of code to PostgreSQL.
I am active on social platforms and advocate for PostgreSQL, migrations, and database internals through my blog.
Social links :- LinkedIn, Twitter , Medium, Planet Postgres Blog, My Talks and More, PostgreSQL Training
No video of the event yet, sorry!
Tuning SQL in PostgreSQL isn’t about chasing magic settings or quick fixes it’s about understanding how the database thinks. In this session, I’ll share a structured approach to finding and fixing slow queries by focusing on fundamentals: identifying problematic SQL, reading execution plans with intent, and connecting what you see in the plan to what the optimizer actually does.
We’ll walk through real-world examples of how small design or join choices change performance, how to interpret key plan nodes, and how to reason about query behavior before reaching for indexes or configuration changes.
This talk is for anyone who wants to build lasting intuition around SQL performance in PostgreSQL not just solve one slow query, but understand why it’s slow.
- Date:
- Duration:
- 45 min
- Room:
- Conference:
- PGConf India, 2026
- Language:
- Track:
- Database Administration
- Difficulty:
- Easy