From: Guillaume Lelarge <guillaume@lelarge.info>
To: Barbara Stephenson <barbara@turbocorp.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Date: Thu, 08 May 2008 09:53:49 +0200
Message-ID: <4822B18D.6020905@lelarge.info> (raw)
In-Reply-To: <200805071538.42882.barbara@turbocorp.com>
References: <200805071538.42882.barbara@turbocorp.com>
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.orghttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, barbara@turbocorp.com
Subject: Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
In-Reply-To: <4822B18D.6020905@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox