Should _bt_pgaddtup, called by _bt_split, pass down LP_DELETE flag? - Mailing list pgsql-hackers

From Toru SHIMOGAKI
Subject Should _bt_pgaddtup, called by _bt_split, pass down LP_DELETE flag?
Date
Msg-id 43DD90CD.0@intellilink.co.jp
Whole thread Raw
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Want to add to contrib.... xmldbx
Next
From: "Raymond"
Date:
Subject: Re: GRANT/REVOKE: Allow column-level privileges