Database Maintenance
Everything on SkillVeris tagged Database Maintenance — collected across the glossary, study notes, blog, and cheat sheets.
4 resources across 1 library
Interview Questions(4)
What is the VACUUM Process in PostgreSQL?
VACUUM is a PostgreSQL maintenance operation that reclaims storage occupied by dead tuples — rows left behind by UPDATE and DELETE under PostgreSQL's MVCC mode…
How Do You Tune Autovacuum in PostgreSQL?
Tuning autovacuum means adjusting how aggressively and how frequently PostgreSQL's background autovacuum workers scan and clean each table, primarily by loweri…
What Causes Table Bloat and How Do You Fix It?
Table bloat is the accumulation of dead or wasted space inside a table's data pages — usually because updates and deletes leave dead tuples faster than autovac…
What is Index Bloat and When Should You Reindex?
Index bloat is wasted space inside a B-tree index caused by deleted or updated entries whose slots are not fully compacted back, and the fix is to run REINDEX…