Greg Smith <g...@2ndquadrant.com> writes: > Does try_relation_open need to have a lock acquisition timeout when AV > is calling it?
Hmm. I think when looking at the AV code, I've always subconsciously assumed that try_relation_open would fail immediately if it couldn't get the lock. That certainly seems like it would be a more appropriate way to behave than delaying indefinitely. In practice, the scenario you're worried about seems unlikely to persist indefinitely: as soon as someone else comes along and blocks behind autovacuum's request, the deadlock checker will kick AV off the lock queue. But it would probably be better not to depend on that. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers