This site is about a previous instance of this event. For the current event, please see the updated site.

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.


Christophe Pettus