Oh I have to look at the other parameters. Once the database is up and it's not vacuuming like we want how do we make changes to the conf file while the database is running? Some signal? Guillaume Lelarge wrote: > 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 -- 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
