title

text

Иван Чувашов
Иван Чувашов Calltouch LLC.
17:45 04 April
45 min

Practical cases for query optimization in PostgreSQL

In my opinion, every DBA has to deal with "heavy" queries. The question is whether we can do something at all to speed up such query. Is it possible to optimize such queries, or maybe it doesn't make sense? For example, rewriting such query may take much longer than getting any performance gain from this rewritten query. During this talk, I'll tackle several approaches to speeding up queries, and demonstrate some practical examples of optimizations that I use at work.

Slides

pgconf2023_new.pptx

Video

Other talks