Presented by:

8e2bdef39ab90aa56f13276b16e11e5d

Jim Nasby

OpenSCG

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

Date:
2017 March 30 09:00
Duration:
50 min
Room:
Liberty I
Conference:
PGConf US 2017
Language:
Track:
Internals
Difficulty:
Medium