How do you maintain indexes and handle bloat in PostgreSQL?

Question

Accepted Answer

Index bloat is dead space inside index pages left behind by updates and deletes. Because PostgreSQL MVCC writes a new row version for every update, indexes accumulate pointers to dead tuples, and a bloated index means more pages read per lookup and a larger cache footprint.