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