Kendra Little trims down the database after Thanksgiving:
Index bloat in Postgres can cause problems, but it’s easy to miss.
I’ve written about how vacuum problems can prevent PostgreSQL from using covering indexes, and index bloat is one of the things that can make vacuum struggle.
Here’s what you need to know about index bloat, how to find it, and how to fix it.
Read on to learn what Kendra means by index bloat, ways in which it can occur, why this is an issue, and how to identify and correct it.