Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER - Mailing list pgsql-general

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.