Re: Cancelling of autovacuums considered harmful

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