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.

1f46996db0de83928504a8ec986bf500

Scott Mead

Amazon Web Services

Scott Mead is a Sr. Database Engineer at Amazon Web Services. He is a 14 year postgres DBA with a background in Enterprise Databases with a focus on large-scale fleet management and monitoring

No video of the event yet, sorry!

Vacuum can be one of the most challenging parts of managing a Postgres database. In this talk we'll walk through common vacuum related issues related to performance, space usage, and the dreaded wraparound. We'll discuss how to avoid these issues, as well as what RDS does to assist.

Topics:

  • MVCC details
  • HOT overview
  • Identifying tuples to be vacuumed/frozen
  • Visibility and Freeze map
  • VACUUM and indexes
  • Autovacuum
  • Vacuum Tuning
  • RDS Adaptive Autovacuum

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
AWS Day
Difficulty:
Medium