build1 publisher
PostgreSQL's VACUUM strands sparse b-tree pages until a REINDEX rebuilds them
In a dev.to case study, PostgreSQL's VACUUM left indexes more than six times the size of their heap because it frees only b-tree pages that empty completely. The post sizes the bloat against the default fillfactor of 90, then rebuilds one index at a time with REINDEX CONCURRENTLY.
Publishers:dev.to
Reality
- Evidence62
- Adoption
- Insufficient
- Hype gap−5
- Incentives
- Insufficient
- Confidence60