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