Scott Marlowe escribió: > As some of you folks know I work on some pretty beefy machines. Some > of these machines don't see rest for months or days on end. And > autovacuum keeps cancelling. I set it more aggressive, it still never > finishes.
No matter how heavily updated, regular activity should not cause autovacuum kills. Only heavier operations would do that (say ALTER TABLE, etc). > We've now had to schedule manual vacuums because autovac never > finishes on large heavily updated tables. > Is there some way to turn off the cancelling of autovacuums? I don't think we have a setting for that. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
