Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum

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 va***ming 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin