Postgres Pro
Downloads
Home   >   mailing lists

Re: [COMMITTERS] pgsql: Improve concurrency of foreign key locking - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Improve concurrency of foreign key locking
Date
Msg-id 28962.1358982879@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Improve concurrency of foreign key locking  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [COMMITTERS] pgsql: Improve concurrency of foreign key locking
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 23 January 2013 17:15, Andres Freund <andres@2ndquadrant.com> wrote:
>> On 2013-01-23 11:58:28 -0500, Andrew Dunstan wrote:
>>> Can't we do better than that?

> "row level locks cannot be applied to the NULLable side of an outer join"

I think it should read "row-level locks cannot ...", but otherwise this
is a fine idea.

> Hint: there are no rows to lock

This bit doesn't seem to be either accurate or helpful, though.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)
Next
From: Phil Sorber
Date:
Subject: Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)