Should _bt_pgaddtup, called by _bt_split, pass down LP_DELETE flag?

Поиск
Список
Период
Сортировка
От Toru SHIMOGAKI
Тема Should _bt_pgaddtup, called by _bt_split, pass down LP_DELETE flag?
Дата
Msg-id 43DD90CD.0@intellilink.co.jp
обсуждение исходный текст
Список pgsql-hackers
Hello Hackers,

_bt_pgaddtup, called by _bt_split, always sets the LP_USED flag
and after that the following transactions access the heap data (which resides on
disk) to check whether the tuple is alive. But this is unnessesary when the
original tuple is not alive, because in this case the new item is necessarily
not alive too. If we passed down the status flag (LP_DELETE/LP_USED), we would
know this and could save one disk access.

I would appreciate your comments on this.

Best regards.

-- 
Toru SHIMOGAKI <shimogakit@intellilink.co.jp>


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Want to add to contrib.... xmldbx
Следующее
От: "Raymond"
Дата:
Сообщение: Re: GRANT/REVOKE: Allow column-level privileges