Re: Still recommending daily vacuum...

Alvaro Herrera wrote:
> So what you are proposing above amounts to setting scale factor = 0.05.
> The threshold is unimportant -- in the case of a big table it matters
> not if it's 0 or 1000, it will be almost irrelevant in calculations.  In
> the case of small tables, then the table will be vacuumed in almost
> every iteration if the threshold is 0, which is fine because the table
> is small anyway.  So why not let the threshold be 0 and be done with it?

For very small tables, setting a threshold of 0 could mean a vacuum 
after every single row update (or every other row). I think that is just 
burning cycles. What about a threshold of 10 or 50, to have at least 
some sanity limit? Even though the cost of vacuum of a small table is 
low, it is still not free, IMHO, no?

Best Regards
Michael Paesold