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 по дате отправления