pgsql: Only allow autovacuum to be auto-canceled by a directly blocked - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Only allow autovacuum to be auto-canceled by a directly blocked
Date
Msg-id E1SuSpV-0004Oc-7B@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Only allow autovacuum to be auto-canceled by a directly blocked process.

In the original coding of the autovacuum cancel feature, commit
acac68b2bcae818bc8803b8cb8cbb17eee8d5e2b, an autovacuum process was
considered a target for cancellation if it was found to hard-block any
process examined in the deadlock search.  This patch tightens the test so
that the autovacuum must directly hard-block the current process.  This
should make the behavior more predictable in general, and in particular
it ensures that an autovacuum will not be canceled with less than
deadlock_timeout grace period.  In the old coding, it was possible for an
autovacuum to be canceled almost instantly, given unfortunate timing of two
or more other processes' lock attempts.

This also justifies the logging methodology in the recent commit
d7318d43d891bd63e82dcfc27948113ed7b1db80; without this restriction, that
patch isn't providing enough information to see the connection of the
canceling process to the autovacuum.  Like that one, patch all the way
back.

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/10b335eabcd34b9e7e9d1c8379e3a63f7d7bf683

Modified Files
--------------
src/backend/storage/lmgr/deadlock.c |   48 ++++++++++++++++++++--------------
1 files changed, 28 insertions(+), 20 deletions(-)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: Document that the pg_upgrade user of rsync might want to skip so
Next
From: Tom Lane
Date:
Subject: pgsql: Only allow autovacuum to be auto-canceled by a directly blocked