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

> Hi,
>=20
> Barbara Stephenson a =E9crit :
> > 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?
> >
>=20
> 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.
>=20
> > 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=3Dtrue
> > track_counts=3Dture
> > log_autovacuum_min_duration=3D1000ms
> > autovacuum_max_workers=3D3(default)
> > autovacuum_naptime=3D60
> > autovacuum_vacuum_threshold=3D50(default)
> >
> > Are the above settings all we need to start auto vacuuming?
>=20
> ISTM you forgot autovacuum_vacuum_scale_factor and the analyze
parameters.
>=20

Are there guides, utilities or web pages published out there that help you
=
determine the optimal settings for these parameters?

How are folks settings these parameters where their product (with
PostgreSQ=
L included) is deployed under various customer environments, say 50
differe=
nt customers?=20

What improvements are occurring to have the PostgreSQL back-end
"auto-tune"=
 these parameters on install or on an ongoing basis?



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