This site is about a previous instance of this event. For the current event, please see the updated site.

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:

Speaker

Alicja Kucharczyk