Schedule - PGConf.EU 2016
Unclogging the VACUUM
Date: 2016-11-02
Time: 11:10–12:00
Room: Alfa 1
Level: Beginner
Perhaps the best-known "feature" of PostgreSQL operations is VACUUM. Ever since version 8.0, autovacuum generally takes care of VACUUM situations for you...
... until it doesn't.
This talk goes over VACUUM pathologies, and how to identify them and repair them. These include:
- Long-running and "stuck" vacuum operations.
- VACUUM FREEZE and its discontents.
- Database access patterns that thwart proper VACUUM operation.
- Monitoring VACUUM, and how to respond.
