Re: foreign key introduces unnecessary locking ?

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: foreign key introduces unnecessary locking ?
Дата
Msg-id 006c01c03d38$43f58280$b57a30d0@sectorbase.com
обсуждение исходный текст
Ответ на Re: foreign key introduces unnecessary locking ?  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-hackers
> Using Dirty transaction removing/updating PK could see that concurrent
> xaction attempts to update/insert FK and so would wait for its
commit/abort.

^^^^^^^^
Of course this will require some function that would take tid as one of
arguments, fetch row and check if someone is updating it.

> Just like now same row writers wait for each other.

Vadim




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