On Sep 18, 2007, at 1:14 AM, Joshua D. Drake wrote:
>> Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
>> reindex/cluster indexes?
>
> If you overrun your max_fsm_pages, no:
> else yes;
my algorithm is: if (true) then yes;
my FSM is way bigger than I ever use (vacuum never reports shortage)
and I still get bloat that needs to be purged out with a reindex on
occasion.