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

From: Toru SHIMOGAKI <shimogakit(at)intellilink(dot)co(dot)jp>
To: undisclosed-recipients: ;
Subject: Should _bt_pgaddtup, called by _bt_split, pass down LP_DELETE flag?
Date: 2006-01-30 04:06:37
Message-ID: 43DD90CD.0@intellilink.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)intellilink(dot)co(dot)jp>

Browse pgsql-hackers by date

  From Date Subject
Next Message Poul Jensen 2006-01-30 04:34:19 Re: Failed install - libgen.so doesn't exist
Previous Message Tom Lane 2006-01-30 04:00:39 Re: Failed install - libgen.so doesn't exist