Scott -- <...>
>To tune autovacuum with 50 databases, start by dropping nap time to >something much lower, like 10s. Then if you need to, drop cost delay >until you get to 0. If you get to 0 and it's still not hitting your >IO too hard, but not keeping up, then increase cost limit. If you get >to something in the 5000 to 10000 range, and its still not keeping up >then start bumping the thread count > Thanks for outlining a strategy on this -- useful advice. Greg Williamson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
