Hi Kevin,

On Sep 26, 2012, at 14:39, Kevin Grittner wrote:
> 
> I am concerned that your initial email said that you had this
> setting:
> 
> autovacuum_naptime = 28800
> 
> This is much too high for most purposes; small, frequently-modified
> tables won't be kept in good shape with this setting.  Perhaps you're
> not having that problem at the moment, but it's risky to assume that
> you don't and never will.  When autovacuum wakes up and there is
> nothing to do it should go back to sleep very quickly.
> 

I used the 28800 (8hours) setting after I realized that the default 1min was 
not helping.
I also changed other parameters when I changed it to 8 hours, to make sure 
tables would be auto vacuumed.
The problem with my setting was that autovacuum gets stopped if a lock is 
needed on the table. So, it was very bad choice to run it every 8 hours, 
because usually it got stopped and never did anything.
So, I turned back to the original setting of 1min but changed the 
autovacuum_vacuum_scale_factor to 1% instead of 20%. Hopefully tables will be 
more frequently vacuumed now and the problem will not appear again.

> Don't expect too much from just making autovacuum run more often
> until you have eliminated existing bloat (autovacuum generally just
> limits further growth of bloat) and updated to the latest 8.4 minor
> release.  The following bugs fixes are among many you are living
> without until you upgrade:

Can you please suggest of a way to 
- find if there is existing bloat
- eliminate it

Thank you

Reply via email to