Re: Autovacuum / full vacuum

["Matthew T. O'Connor" <matthew@xxxxxxxx>]

Michael Riess wrote:
> did you read my post? In the first part I explained why I don't want to 
> increase the FSM that much.

I'm sure he did, but just because you don't have enough FSM space to 
capture all everything from your "burst", that doesn't mean that space 
can't be reclaimed.  The next time a regular vacuum is run, it will once 
again try to fill the FSM with any remaining free space it finds in the 
table.  What normally happens is that your table will never bee 100% 
free of dead space, normally it will settle at some steady state size 
that is small percentage bigger than the table will be after a full 
vacuum.  As long as that percentage is small enough, the effect on 
performance is negligible.  Have you measured to see if things are truly 
faster after a VACUUM FULL?

Matt