Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: > On Mon, 2005-05-09 at 15:18 -0400, Tom Lane wrote: >> ... usually. We will promote later arrivals in front of older ones if >> the alternative would be a deadlock (eg, the later one already holds >> some lock that would block the earlier one). > Thats part of deadlock detection? I had thought we just blew one away... Only after deciding that there's no way to rearrange the lock queues to eliminate the deadlock. regards, tom lane