Mastering PostgreSQL Performance: A Systematic Approach to Query Tuning and Optimization
Presented by:
Janis Griffin
Janis Griffin has over 30+ years of DBA/database experience including design, development, and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning and management.
No video of the event yet, sorry!
Achieving peak performance in PostgreSQL databases requires mastering the art of query tuning. Developers and DBAs often grapple with diagnosing and resolving performance bottlenecks, wasting valuable time on trial-and-error approaches. This session introduces a systematic methodology for tuning PostgreSQL queries, leveraging tools like Wait Time analysis, explain plans, and SQL diagramming. Attendees will learn to identify costly operations, select optimal execution plans, and apply proven best practices through real-world case studies. Whether you are a novice or an experienced professional, this presentation will empower you to optimize queries efficiently, streamline database performance, and save countless hours in troubleshooting.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Dev
- Difficulty:
- Medium