Re: postgresql locks the whole table!

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: postgresql locks the whole table!
Дата
Msg-id 878ylo1nlj.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: postgresql locks the whole table!  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: postgresql locks the whole table!
Re: postgresql locks the whole table!
Список pgsql-general
It's not strictly necessary to have a list of all xids at all. The normal
"shared read lock" is just "take the write lock, increment the readers
counter, unlock" Anyone who wants to write has to wait (using, eg, a condition
variable) until the readers count goes to 0.

This gets the right semantics but without the debugging info of a list of
lockers. Other than debugging the only advantage I see to having the list of
lockers is for deadlock detection. Is that absolutely mandatory?

--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE RULE problem/question requesting workaround
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: postgresql locks the whole table!