8.x Vaccum/Autovacuum settings

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: 8.x Vaccum/Autovacuum settings
Date: 2006-06-24 22:03:39
Message-ID: 1d219a6f0606241503k3ae3e7d6lb1675fcb8b61bbc3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dawid Kuroczko 2006-06-25 12:01:47 Re: 8.x Vaccum/Autovacuum settings
Previous Message hubert depesz lubaczewski 2006-06-24 09:25:25 Re: Is it possible to trace all transactions done?