UTOUG Training Days 2025: Full Schedule

1:15pm MDT

Can Oracle DBAs/Developers Tune Queries in PostgreSQL?

Monday March 24, 2025 1:15pm - 2:00pm MDT

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.

Speakers

Janis Griffin

Senior Systems Consultant, Quest Software

Janis Griffin has more than 35 years of Oracle DBA experience, including the design, development, and implementation of critical database applications. Before joining Quest, she held DBA positions primarily in the telecom and network industries, working with real-time network routing... Read More →

Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 224

Beyond Oracle, Development

UTOUG Training Days 2025

From $50.00