Why does L&Y Blink Tree need lock coupling?

Поиск
Список
Период
Сортировка
От Oliver Yang
Тема Why does L&Y Blink Tree need lock coupling?
Дата
Msg-id CALJbhHPiudj4usf6JF7wuCB81fB7SbNAeyG616k+m9G0vffrYw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why does L&Y Blink Tree need lock coupling?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Hi,

The README in nbtree mentions that L&Y algorithm must couple
locks when moving right during ascent for insertion.  However,
it's hard to see why that's necessary.  Since L&Y mostly
discussed concurrent insertions and searches, what can go wrong
if inserters only acquire one lock at a time?

The Lanin&ShaSha paper cited in README also agrees that B-link
structure allows inserts and searches to lock only one node at a
time although it's not apparent in L&Y itself.



Thanks,

Hong

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Checksum errors in pg_stat_database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Checksum errors in pg_stat_database