Re: Odd Locking Problem

Поиск
Список
Период
Сортировка
От John A Meinel
Тема Re: Odd Locking Problem
Дата
Msg-id 42FBDF94.5060104@arbash-meinel.com
обсуждение исходный текст
Ответ на Re: Odd Locking Problem  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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
=:->

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeffrey Tenny
Дата:
Сообщение: Re: Mostly read performance
Следующее
От: Michael Stone
Дата:
Сообщение: Re: PG8 Tuning