Converting from 7.4.19 To 8.3.1 & want to use autovacuum - Mailing list pgsql-admin

From Barbara Stephenson
Subject Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Date
Msg-id 200805071538.42882.barbara@turbocorp.com
Whole thread Raw
Responses Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
List pgsql-admin
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

pgsql-admin by date:

Previous
From: mcravitz@att.net
Date:
Subject: Can't connect remotely
Next
From: "Kevin Grittner"
Date:
Subject: Re: Can't connect remotely