PostgreSQL Query Tuning: A Foundation Every Database Developer Should Build
PostgreSQL Query Tuning: A Foundation Every Database Developer Should Build
Speaker: Deepak R Mahto (DataCloudGaze Consulting)
🔗 https://live.pgconf.in/events/pgconf-...
PGConf India 2026 — Asia's Premier PostgreSQL Conference
March 11-13, 2026 | Sheraton Grand Hotel, Bangalore
https://pgconf.in
---
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.