On Mon, Dec 5, 2011 at 11:36 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > Ernesto Quiñones<ernestoq@xxxxxxxxx> wrote: >> vacuum_cost_limit 200 > We've boosted this to 600. Once you're in a "steady state", this is > the setting you might want to adjust up or down as needed to make > cleanup aggressive enough without putting a noticeable dent in > performance while it is running. On the busy production systems I've worked on in the past, we had this cranked up to several thousand along with 10 or so workers to keep up on a busy machine. The more IO your box has, the more you can afford to make vacuum / autovacuum aggressive. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
