We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

All the Dirt on VACUUM

195
 Cite
 Share
 Related Material
 Download
 Purchase
No logo availablePGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
 Jim Nasby,

Formal Metadata

Title
All the Dirt on VACUUM
Title of Series
Number of Parts
29
Author
Contributors
License
CC Attribution - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date2015
LanguageEnglish
Production PlaceOttawa, Canada

Content Metadata

Subject Area
Genre
Abstract
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