All the dirt on VACUUM: 9.6 edition
Jim Nasby 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.
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 Visibility and Freeze map VACUUM and indexes Vacuuming heap pages
- 50 min
- PGConf US 2017