Can SQL Server DBAs/Developers Tune Queries in PostgreSQL?

Janis Griffin

Let’s face it, query tuning is key to peak performance in any database. However, if you are primarily SQL Server-focused and you’re suddenly tasked with tuning PostgreSQL queries, that task can seemingly become daunting.

Lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time trying to fix them. In this presentation, I will share my tried-and-true best practices for tuning PostgreSQL statements and other issues. By utilizing Wait Time analysis, reviewing explain plans, and giving tips on which operations to look out for, you will be able to quickly tune queries that are affecting performance. In addition, we’ll explore SQL diagramming techniques to find the best execution plan and several case studies will be used to demonstrate these best practices.

Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing – saving countless hours of tuning queries and optimizing performance of your PostgreSQL databases.