Re: HOT updates & REDIRECT line pointers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: HOT updates & REDIRECT line pointers
Date
Msg-id 12732.1332375212@sss.pgh.pa.us
Whole thread Raw
In response to Re: HOT updates & REDIRECT line pointers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: HOT updates & REDIRECT line pointers  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
I wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Specifically, I'm wondering if we couldn't get away with rearranging
>> things so that the root line pointer (which has index entries) points
>> to the actual tuple, and the other line pointer (which can't have any
>> index entries) gets marked UNUSED.

> This would amount to changing the TID of the live row.

Another issue, quite independent from race conditions against other
observers of the row, is what if the tuple is part of an update chain?
You have no way to find the predecessor row version and update its
t_ctid forward link.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HOT updates & REDIRECT line pointers
Next
From: Tom Lane
Date:
Subject: Re: Proposal: Create index on foreign table