Postgres FM Index maintenance
Sep 23, 2022
The podcast discusses the importance of index maintenance in PostgreSQL databases, exploring bloat analysis, redundant indexes, and the relationship between index usage and bloat. The hosts emphasize the negative impact of not using indexes, caution against certain tools due to potential bugs, and highlight the use of vacuum in parallel and the importance of partitioning for efficient database maintenance.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 2min
The Impact of Index Maintenance and Vacuuming on Heavily Loaded Systems
01:52 • 18min
Removing Bloat and Redundant Indexes
19:47 • 6min
Exploring the Relationship Between Index Usage and Bloat
26:00 • 2min
Index Overhead, Fighting Bloat, and Gene Indexes
27:39 • 2min
Using Vacuum in Parallel and the Importance of Partitioning
30:08 • 3min