Re: Odd Locking Problem

From: John A Meinel <john(at)arbash-meinel(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Odd Locking Problem
Date: 2005-08-11 23:30:28
Message-ID: 42FBDF94.5060104@arbash-meinel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
=:->

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2005-08-11 23:54:44 Re: PG8 Tuning
Previous Message Jeffrey Tenny 2005-08-11 23:13:27 Re: Mostly read performance