Autoplay
Autocomplete
Previous Lecture
Complete and continue
Postgres: Fundamentals of Vacuum 2027 (Early Access)
Making Sure You're Ready for Class: Free Prerequisites
Concepts to Grasp First
Getting Your Computer Ready
Explaining Why Table Performance Degrades
How Postgres Stores Data in 8KB Pages (12:06)
Unvacuumed Tables are Bigger and Slower (14:20)
How Indexes are Affected Too (12:13)
How Autovacuum Tries to Fix It in the Background
What Autovacuum Does - and Doesn't Do (10:50)
Autovacuum Problem 1: Many Active Tables (16:33)
Autovacuum Problem 2: Blocking on a Single Table (12:27)
How Postgres Stores Data in 8KB Pages
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock