Let's turn off the vacuum?!

Alexey Lesovsky

Data Egret

PostgreSQL DBA

PostgreSQL DBA and Linux system administrator with more than 10 years of IT-experience, including server administration of Linux and use of KVM-virtualization. The last 5 years experience was focused on maintenance of PostgreSQL databases.

When one faces the issues with PostgreSQL, the main suspicion falls on vacuum. Experience of Data Egret team proves how many DBAs are attacking this rake. While there are tons of information, documentation and discussions on vacuum itself, the topic is still associated with a lot of myths, tales, horror stories and misconceptions. In my talk I will try to reveal the key points concerning the inner structure of vacuum, basic approaches to its adjustment and tuning, performance monitoring, and so on.