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

Nordic PGDay 2018

Schedule - Nordic PGDay 2018

PostgreSQL Query optimisation, step by step

Date: 2018-03-13
Time: 14:30–15:20
Room: Spikerverket

Sooner or later you run into situation, when it is no more possible to improve performance of your beloved database-interacting project only by changing some postgresql.conf settings. It is time, when you need to optimize some SQL-queries, and such optimization can turn out to be not a last-mile problem, but a long difficult journey. How to choose queries to optimize? OK, I know about explain, but how to interpret its output? How to improve bad queries? How can that affect overall performance? In this talk I will guide you through the answers. We will learn how to pick up queries to optimize, will scrutinize their explains and optimize them. Besides, I will give some tips, how to check your queries before they can cause performance problems.


The following slides have been made available for this session:


Ilya Kosmodemiansky