Date: 2015-10-30
Time: 10:50–11:40
Room: Ballroom C+D
Level: Intermediate
What is autovacuum, how it works and why is it so important? In this talk, I will cover PostgreSQL MVCC and Undo-management basics, problems and hazards of misconfigured autovacuum, a couple of strategies on how to make your PostgreSQL installation feel happy about autovacuum. In addition I will show a couple of bloat-removing techniques and give some advices on how to monitor autovacuum activity in your database.