Re: Safely calling index_getprocinfo() while holding an nbtree exclusive buffer lock

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Safely calling index_getprocinfo() while holding an nbtree exclusive buffer lock
Дата
Msg-id 31431.1547521959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Safely calling index_getprocinfo() while holding an nbtree exclusivebuffer lock  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Safely calling index_getprocinfo() while holding an nbtreeexclusive buffer lock  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Дерево обсуждения 
Peter Geoghegan <pg@bowt.ie> writes:
> My nbtree patch [1] needs to call index_getprocinfo() with an
> exclusive buffer lock held during a leaf page split.

I think you should stop right there and ask why.  Surely that info
can be obtained before starting the operation?  Quite aside from the
deadlock hazard, I do not think holding an exclusive buffer lock
for long enough to go consult a system catalog will be acceptable
from a performance/concurrency standpoint.

            regards, tom lane

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Safely calling index_getprocinfo() while holding an nbtree exclusivebuffer lock
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: could recovery_target_timeline=latest be the default in standbymode?