Hi,
Barbara Stephenson a écrit :
We are new about autovacuum launcher on 8.3.1 and we are not sure what the
parameters should be set to. Is setting them to default ok until we can
monitor if it's vacumming too much?
You can do that. But the default are, as always with PostgreSQL, really
conservative. So you'll probably need to change them because it will not
vacuum enough.
Below are the parameters that we think are the only params we need to do a
basic vacuum and analyze to our entire database.
autovacuum=true
track_counts=ture
log_autovacuum_min_duration=1000ms
autovacuum_max_workers=3(default)
autovacuum_naptime=60
autovacuum_vacuum_threshold=50(default)
Are the above settings all we need to start auto vacuuming?
ISTM you forgot autovacuum_vacuum_scale_factor and the analyze parameters.
Regards.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com