Should heap_update/heap_delete hold buffer locks while toasting?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Should heap_update/heap_delete hold buffer locks while toasting?
Дата
Msg-id 6397.978905433@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Should heap_update/heap_delete hold buffer locks while toasting?  (Jan Wieck <janwieck@Yahoo.com>)
Список pgsql-hackers
The way that heap_update() and heap_delete() are currently coded, they
hold the buffer context lock on the buffer containing the old tuple
while they invoke heap_tuple_toast_attrs().  This strikes me as at least
inefficient and at worst a source of deadlock.  Is it possible to avoid
holding the buffer lock while doing the TOAST manipulations?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: heap_update is broken in current sources
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: CVS regression test failure on OBSD