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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org