Greg Smith <greg(at)2ndquadrant(dot)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

In response to

• Re: We need to log aborted autovacuums at 2011-01-15 09:47:56 from Greg Smith

Responses

• Re: We need to log aborted autovacuums at 2011-01-15 19:29:54 from Robert Haas

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2011-01-15 16:15:45
	Subject: Re: log_hostname and pg_stat_activity
Previous:	From: Tom Lane	Date: 2011-01-15 16:08:48
	Subject: Re: Add support for logging the current role