Optimization of PostgreSQL Queries: Everything You Need to Know in Practice

We all love optimization tasks. Especially when it comes to code, and to a lesser extent when it comes to the data layer. Working effectively with databases is not an easy task, but it is no less interesting and necessary. During the talk, we will master the minimum set of skills that will allow us to successfully solve this problem for PostgreSQL in most cases.