Index Bloat

Causes of Index Bloat:

  • Large churning of data on a table.
  • Every time you vacuum or vacuum analyze a table, this will cause index bloat.
  • Vacuum does not vacuum the indexes.

In this presentation we will go over how to find index bloat, monitor index bloat, and fix index bloat.