PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Jim Nasby
Day Talks - Day 4 - Friday - 2015-06-19
Room DMS 1120
Start time 11:00
Duration 00:45
ID 829
Track DBA
Language used for presentation English

All the Dirt on VACUUM

The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does.

Topics: - MVCC details - HOT overview - Identifying tuples to be vacuumed/frozen - VACUUM and indexes - Vacuuming heap pages