PGCon2019 - 1.0.8

PGCon 2019
The PostgreSQL Conference

Alexander Korotkov
Day Talks - Day 1 - 2019-05-30
Room DMS 1120
Start time 14:00
Duration 00:45
ID 1303
Event type Lecture
Track Performance
Language used for presentation English

PostgreSQL bottlenecks

Why my database is running slow?

It's so good when database behaves predictable. When the performance is lacking, you just add CPU cores, terabytes of RAM and millions of IOPS. Then everything becomes good again. But it's rather unpleasant, when server have plenty of free resources, but database is still running slow. And it's especially sad if stress testing detects no problems, while real life workload of the same volume makes your database hang.

In this talk I will consider bottlenecks of PostgreSQL, which we met in our practice and which causes the sad behavior described above. I'll also explain what can be done at the user level in order to evade these bottlenecks, and what developers are planning to do in order to eliminate those bottlenecks. I'm also planning give some recipes of stress testing, which could help to evade surprises in production.