Postgres Pro
Downloads
Home   >   mailing lists

8.x Vaccum/Autovacuum settings - Mailing list pgsql-admin

From Chris Hoover
Subject 8.x Vaccum/Autovacuum settings
Date
Msg-id 1d219a6f0606241503k3ae3e7d6lb1675fcb8b61bbc3@mail.gmail.com
Whole thread Raw
Responses Re: 8.x Vaccum/Autovacuum settings  ("Dawid Kuroczko" <qnex42@gmail.com>)
Re: 8.x Vaccum/Autovacuum settings  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-admin
Tree view
Just curious,

What are most of you setting your vacuum and autovacuum parameters to for your 8.x databases.  I just turned on autovacuuming on one of my db servers and went with a very conservative vacuum_cost_delay of 200 and vacuum_cost_limit of 50.  I am wondering if anyone else has tested to find out just how far you can push your vacuum/autovacuum before you start to feel performance hits from running it?

Thanks,

Chris

P.S. 

I chose these numbers based upon the documentation at http://www.powerpostgresql.com/Downloads/annotated_conf_80.html

pgsql-admin by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: Is it possible to trace all transactions done?
Next
From: "Dawid Kuroczko"
Date:
Subject: Re: 8.x Vaccum/Autovacuum settings