Schedule - PGConf.DE 2022

PostgreSQL Query optimisation, step by step

Date: 2022-05-13
Time: 12:50–13:35
Room: South Dakota
Level: Beginner
Feedback: Leave feedback

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