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

Reply via email to