All the dirt on VACUUM: 11 edition
Jim discovered a passion for data and databases early in life, and was working as a database consultant before high school. Since then he has worked with everything from Foxpro to Oracle. For the past 15 years he has specialized in PostgreSQL and is an active member of it's development community. He specializes in tackling complex data challenges where data quality is critical.
No video of the event yet, sorry!
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.
- MVCC details
- HOT overview
- Identifying tuples to be vacuumed/frozen
- Visibility and Freeze map
- VACUUM and indexes
- Vacuuming heap pages
- 2019 March 21 13:00
- 50 min
- Postgres Conference
- Ops and Administration