Re: deadlock_timeout at < PGC_SIGHUP? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: deadlock_timeout at < PGC_SIGHUP?
Date
Msg-id 1301408551-sup-7970@alvh.no-ip.org
Whole thread Raw
In response to Re: deadlock_timeout at < PGC_SIGHUP?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Excerpts from Greg Stark's message of mar mar 29 11:15:50 -0300 2011:

> Alternatively we could have the deadlock timer reset all the time and
> fire repeatedly. Then we could just have all backends ignore the
> deadlock if they're not the lowest priority session in the cycle. But
> this depends on everyone knowing everyone else's priority (and having
> a consistent view of it).

Presumably it'd be published in MyProc before going to sleep, so it'd be
available for everyone and always consistent.  Not sure if this requires
extra locking, though.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: deadlock_timeout at < PGC_SIGHUP?
Next
From: Dimitri Fontaine
Date:
Subject: Re: Another swing at JSON