
Andrey Zubkov
PostgresPro
16:30
01 April
40 min
Vacuum Research Using Extended Statistics
For over a year, Postgres Pro has provided extended vacuum statistics, reflecting its operation on individual relations.
We've started receiving observations from production databases of clients that include these statistics. It has been quite successful, and in 2024, we began actively promoting vacuum statistics in PostgreSQL. In this talk, we will review what these statistics can tell us about the complex life of vacuum, using real-world data from live systems.