UTOUG Training Days 2025

Query tuning is essential for peak performance in any database. However, if you're Oracle-focused and suddenly tasked with tuning PostgreSQL queries, the challenge can seem daunting. Many developers and DBAs struggle to pinpoint the root cause of performance issues and often spend too much time trying to resolve them.

In this presentation, I’ll share my proven best practices for tuning PostgreSQL queries and addressing other performance issues. By using Wait Time analysis, reviewing explain plans, and offering tips on key operations to watch out for, you'll learn how to quickly tune queries impacting performance. We’ll also cover SQL diagramming techniques to identify the best execution plan, supported by case studies demonstrating these practices.

Regardless of your database’s complexity or your skill level, this systematic approach will guide you to the right tuning path, eliminating guesswork and saving countless hours in optimizing PostgreSQL performance.