From: Barbara Stephenson <barbara@turbocorp.com>
To: pgsql-admin@postgresql.org
Subject: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Date: Wed, 7 May 2008 15:38:42 -0400
Message-ID: <200805071538.42882.barbara@turbocorp.com> (raw)
Hello,
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?
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?
--
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
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: barbara@turbocorp.com
Subject: Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
In-Reply-To: <200805071538.42882.barbara@turbocorp.com>
* 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