Cancelling of autovacuums considered harmful - Mailing list pgsql-general

From Scott Marlowe
Subject Cancelling of autovacuums considered harmful
Date
Msg-id CAOR=d=30mNKych=09dR3LHjr8xZ0WGWjXignYaXyZ7fj-gFNxg@mail.gmail.com
Whole thread Raw
Responses Re: Cancelling of autovacuums considered harmful  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Cancelling of autovacuums considered harmful  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
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.

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?


pgsql-general by date:

Previous
From: Rob Richardson
Date:
Subject: How can I correctly handle sparse crosstabs?
Next
From: Joe Conway
Date:
Subject: Re: How can I correctly handle sparse crosstabs?