From: Barbara Stephenson <barbara@turbocorp.com>
To: pgsql-admin@postgresql.org
Subject: Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Date: Thu, 8 May 2008 07:51:54 -0400
User-Agent: KMail/1.7.1
Cc: Guillaume Lelarge <guillaume@lelarge.info>
References: <200805071538.42882.barbara@turbocorp.com>
	<4822B18D.6020905@lelarge.info>
In-Reply-To: <4822B18D.6020905@lelarge.info>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200805080751.54596.barbara@turbocorp.com>

Oh I have to look at the other parameters.  Once the database is up and it'=
s=20
not vacuuming like we want how do we make changes to the conf file while th=
e=20
database is running? Some signal?

Guillaume Lelarge wrote:
> Hi,
>
> 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 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=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?
>
> ISTM you forgot autovacuum_vacuum_scale_factor and the analyze parameters.
>
> Regards.
>
>
> --
> Guillaume.
>   http://www.postgresqlfr.org
>   http://dalibo.com

=2D-=20
Regards,

Barbara Stephenson
EDI Specialist/Programmer
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA  30507
tel: (678)989-3020 fax: (404)935-6171
barbara@turbocorp.com
www.ohlogistics.com