Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Converting from...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 4965 of 5130
Post > Topic >>

Converting from 7.4.19 To 8.3.1 & want to use autovacuum

by barbara@[EMAIL PROTECTED] (Barbara Stephenson) May 7, 2008 at 03:38 PM

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@[EMAIL PROTECTED]
 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 4 Posts in Topic:
Converting from 7.4.19 To 8.3.1 & want to use autovacuum
barbara@[EMAIL PROTECTED]  2008-05-07 15:38:42 
Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
guillaume@[EMAIL PROTECTE  2008-05-08 09:53:49 
Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
barbara@[EMAIL PROTECTED]  2008-05-08 07:51:54 
Re: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Eric.Comeau@[EMAIL PROTEC  2008-05-08 05:34:47 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 23:20:48 CDT 2008.