Re: Concurrency - Mailing list pgsql-admin

From Tom Lane
Subject Re: Concurrency
Date
Msg-id 1937.1115675189@sss.pgh.pa.us
Whole thread Raw
In response to Re: Concurrency  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
Simon Riggs <simon@2ndquadrant.com> 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

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Concurrency
Next
From: "Subbiah, Stalin"
Date:
Subject: pg_toast_xxxxxx_index is not a btree error