Re: FOR KEY LOCK foreign keys - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: FOR KEY LOCK foreign keys
Date
Msg-id 1295028859-sup-6640@alvh.no-ip.org
Whole thread Raw
In response to Re: FOR KEY LOCK foreign keys  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Excerpts from Robert Haas's message of vie ene 14 15:08:27 -0300 2011:
> On Fri, Jan 14, 2011 at 1:00 PM, David E. Wheeler <david@kineticode.com> wrote:
> > On Jan 13, 2011, at 1:58 PM, Alvaro Herrera wrote:
> >
> >> Something else that might be of interest: the patch as presented here
> >> does NOT solve the deadlock problem originally presented by Joel
> >> Jacobson.  It does solve the second, simpler example I presented in my
> >> blog article referenced above, however.  I need to have a closer look at
> >> that problem to figure out if we could fix the deadlock too.
> >
> > Sounds like a big win already. Should this be considered a WIP patch, though, if you still plan to look at Joel's
deadlockexample?
 
> 
> Alvaro, are you planning to add this to the CF?

Eh, yes.

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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: FOR KEY LOCK foreign keys
Next
From: Tom Lane
Date:
Subject: Re: limiting hint bit I/O