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