Presented by:

434b65f0e5bd90328432a48ae16697cd

Jim Nasby (jim.nasby@bluetreble.com)

Partner at Blue Treble

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.

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. 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 12:50
Duration:
50 min
Room:
Liberty I
Conference:
PGConf US 2017
Language:
Track:
Internals
Difficulty:
Medium