Schedule - PGConf.EU 2017
From minutes to milliseconds – Tips and tricks for faster SQL queries
Date: 2017-10-27
Time: 09:30–10:20
Room: Baltic II+III
Level: Beginner
Bad SQL is one of the most common performance issues. The use of ORM frameworks and treating a database as a data store only leads to slow queries which slow down the whole system. I’ll discuss some basic techniques every developer should be aware of, along with some examples from production systems of query tuning using different approaches from modifications of joins and subqueries to adjusting the planer cost settings and other parameters that affect the way a query is executed. Besides, I’ll present some techniques to benchmark a query performance in a reliable and automated manner.
Slides
The following slides have been made available for this session:
