Re: foreign key locks, 2nd attempt

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: foreign key locks, 2nd attempt
Дата
Msg-id 201111101959.pAAJxKl14538@momjian.us
обсуждение исходный текст
Ответ на foreign key locks, 2nd attempt  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: foreign key locks, 2nd attempt
Список pgsql-hackers
Alvaro Herrera wrote:
> Hello,
> 
> After some rather extensive rewriting, I submit the patch to improve
> foreign key locks.
> 
> To recap, the point of this patch is to introduce a new lock tuple mode,
> that lets the RI code obtain a lighter lock on tuples, which doesn't
> conflict with updates that do not modify the key columns.

What kind of operations benefit from a non-key lock like this?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: const correctness
Следующее
От: Tom Lane
Дата:
Сообщение: Re: const correctness