Bloated indexes prevent efficient index-only scans

Index bloat degrades performance of covering indexes. Even when using index-only scans, bloated indexes require scanning more pages than necessary to satisfy queries.

Monitor index bloat metrics. Use REINDEX CONCURRENTLY to rebuild heavily bloated indexes without blocking reads or writes. Schedule periodic concurrent reindexing for covering indexes.