PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Jim Nasby |
| Schedule | |
|---|---|
| Day | Talks - Day 4 - Friday - 2015-06-19 |
| Room | DMS 1120 |
| Start time | 11:00 |
| Duration | 00:45 |
| Info | |
| 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