Query optimization in PostgreSQL

Master class for developers who have already tried all the basic methods for speeding up queries, for example N+1 and added all kinds of indexes, but want to achieve better results. What to do next? There is no simple answer, you will have to figure out how it all works. This is what we will do.

This master class will be useful for those who want to stop juggling subqueries at random, and are ready to dive deeper into how PostgreSQL works to learn how to find the reasons for slow queries.

PostgreSQL is an amazing database data, which itself does an excellent job of optimization, in 95% of cases.

We'll talk about the remaining 5%, and to help PostgreSQL, we'll have to learn to think like a database. 

< strong>At the master class:

• Let's see how the PostgreSQL scheduler works
• Let's learn to love seq scan and think like database
• Let's figure out how PostgreSQL reads and processes data
• We'll discuss views, materialized views, CTE and other things that you and you know, but are not sure how they will affect the speed of work
• Let's talk about selectivity, statistics and indexes