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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
