The nice thing about index bloat is REINDEX has a CONCURRENTLY option, no need to block writes.
Re:PostgreSQL 16 Released
by paulddraper on Thursday September 14, 2023 @11:50PM
(#37518125)
True, good point.
Parent literally provided one: deleting a column.
Another is that it's very easy in PostgreSQL to bloat indexes. Load a bunch of data. Update (or delete) that data and now your index is bloated.
The only resolution is to REINDEX (or VACUUM FULL).