Message-ID: <4822B18D.6020905@lelarge.info>
Date: Thu, 08 May 2008 09:53:49 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)
MIME-Version: 1.0
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
References: <200805071538.42882.barbara@turbocorp.com>
In-Reply-To: <200805071538.42882.barbara@turbocorp.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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