Converting from 7.4.19 To 8.3.1 & want to use autovacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx
www.ohlogistics.com


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux