Михаил Жилин — Как PostgreSQL может сделать больно, когда не ожидаешь?

Description:

The talk examines performance issues in PostgreSQL, focusing on scenarios where conventional query optimization fails. The speaker shares experiences with index scans that unexpectedly slow queries, indexes not being used, unexpected table blocking, and how latency between the application and the database can become a critical performance factor.