PostgreSQL Unused Indexes and Index Bloat: A Safe Cleanup Checklist
Find PostgreSQL unused indexes and bloat with catalog queries, then drop or rebuild them safely by checking stats history, constraints, replicas, and locks.
15 min read
Tag
index bloat
PostgreSQL Index Bloat: Measure It, Then REINDEX CONCURRENTLY
Learn to measure PostgreSQL index bloat with pgstattuple, decide if a rebuild is justified, and run REINDEX CONCURRENTLY safely, including failure recovery.
13 min read