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
Список
Дерево обсуждения
Should heap_update/heap_delete hold buffer locks while toasting? Tom Lane <tgl@sss.pgh.pa.us>
Re: Should heap_update/heap_delete hold buffer locks while toasting? Jan Wieck <janwieck@Yahoo.com>
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
Дата:
От: Peter Eisentraut
Дата:
FAQ