Presented by:

Badge

Jim Nasby

Amazon Web Services

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.

Topics

  • MVCC details
  • HOT overview
  • Identifying tuples to be vacuumed/frozen
  • Visibility and Freeze map
  • VACUUM and indexes
  • Vacuuming heap pages

Date:
2017 November 14 16:40 UTC
Duration:
50 min
Room:
Metropolitan B
Conference:
PGConf Local: Seattle [PgConf.US]
Language:
Track:
ops
Difficulty:
Hard