Fix autovacuum for shared relations
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 10 May 2016 19:23:54 +0000 (16:23 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 10 May 2016 19:23:54 +0000 (16:23 -0300)
commitca4c6d043ffa6233d4cc47ef2e117e2e52a79e11
treea0c019e34de38afbf2fbee033a58a68762cd6aa1
parente9dca8ce147f32d7d64a9e64f9d8339310ad6535
Fix autovacuum for shared relations

The table-skipping logic in autovacuum would fail to consider that
multiple workers could be processing the same shared catalog in
different databases.  This normally wouldn't be a problem: firstly
because autovacuum workers not for wraparound would simply ignore tables
in which they cannot acquire lock, and secondly because most of the time
these tables are small enough that even if multiple for-wraparound
workers are stuck in the same catalog, they would be over pretty
quickly.  But in cases where the catalogs are severely bloated it could
become a problem.

Backpatch all the way back, because the problem has been there since the
beginning.

Reported by Ondřej Světlík

Discussion: https://www.postgresql.org/message-id/572B63B1.3030603%40flexibee.eu
https://www.postgresql.org/message-id/572A1072.5080308%40flexibee.eu
src/backend/postmaster/autovacuum.c