Re: Odd Locking Problem - Mailing list pgsql-performance

From John A Meinel
Subject Re: Odd Locking Problem
Date
Msg-id 42FBDF94.5060104@arbash-meinel.com
Whole thread Raw
In response to Re: Odd Locking Problem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-performance
Alvaro Herrera wrote:
> On Thu, Aug 11, 2005 at 03:36:31PM -0500, John A Meinel wrote:
>

...

>
> This is a known problem, solved in 8.1.  A workaround for previous
> releases is to defer FK checks until commit:

So I don't know exactly what the fix was, but I just tested, and my
problem is indeed fixed with the latest CVS head. It no longer blocks.

>
> create table b (a int references a initially deferred);
>

John
=:->

Attachment

pgsql-performance by date:

Previous
From: Jeffrey Tenny
Date:
Subject: Re: Mostly read performance
Next
From: Michael Stone
Date:
Subject: Re: PG8 Tuning