Re: Auto vacuum

On Thursday 19 April 2007 13:54, Carol Walter wrote:
> I certainly appreciate the help you've given. Here's what the code
> in this part of postgresql.conf file says.
>
> autovacuum = on
>
> autovacuum_naptime = 30 # time between autovacuum runs, in secs
> autovacuum_vacuum_threshold = 500 # min # of tuple updates before
> # vacuum
> autovacuum_analyze_threshold = 250 # min # of tuple updates before
> # analyze
> autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
> # vacuum
> autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
> # analyze
> autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
> # autovac, -1 means use
> # vacuum_cost_delay
> #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
> # autovac, -1 means use
> # vacuum_cost_limit
>

Do you know if you have done a reload of the config files since these were
changed? Try doing a select * from pg_settings where name ~ 'autovacuum' to
see what your db is currently using.

--
Robert Treat
Database Architect
http://www.omniti.com