Database Training Days 101: Top 5 PostgreSQL Query Tuning Tips with Janis Griffin

Performance tuning can be complex, and it’s often challenging to know which adjustments will yield the most significant performance improvements. In this presentation, Janis Griffin, Quest Senior Sales Engineer, will guide you through five essential steps to identify and resolve performance issues swiftly. Whether you're new to performance tuning or looking to sharpen your skills, this session will equip you with the knowledge to fine-tune SQL statements effectively, avoid future performance inhibitors, and understand how execution plans work to optimize performance.

Topics that will be discussed include:

• Quickly fine-tuning SQL statements for optimal performance
• Identifying and mitigating performance inhibitors to prevent future issues
• Recognizing costly steps in query execution
• Understanding and optimizing execution plans

Speaker:

• Janis Griffin, Senior Sales Engineer at Quest Software