admin control over cancelling autovacuum when blocked by a lock

From: John Lumby <johnlumby(at)hotmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: admin control over cancelling autovacuum when blocked by a lock
Date: 2019-04-29 21:02:40
Message-ID: DM6PR06MB556272F9CB7629B10CE86829A3390@DM6PR06MB5562.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

If a regular backend worker becomes blocked waiting for a lock held by an autovacuum worker,
then , depending on some decision made by deadlock detector,
the autovacuum worker may be signalled to terminate

This results in messages such as these in the statement log

ERROR: canceling autovacuum task
CONTEXT: automatic vacuum of table "somedb.aschema.thistable"

Is there any configuration parameter which controls this?
including deferring or even completely eliminating this cancelling?
so that, in the eliminate case, the waiter would simply go on waiting
until the autovacuum eventually finishes "thistable"?

I have not seen any parameter to do this.
Note that I don't mean some parameter which affects all locking behaviour,
only this autovacuum case.

Cheers, John Lumby

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2019-04-29 23:15:08 Re: admin control over cancelling autovacuum when blocked by a lock
Previous Message Alex Balashov 2019-04-29 10:44:20 Re: Physical replication slots and xlog space exhaust