Re: HOT updates & REDIRECT line pointers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: HOT updates & REDIRECT line pointers
Дата
Msg-id 12732.1332375212@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: HOT updates & REDIRECT line pointers  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: HOT updates & REDIRECT line pointers
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: HOT updates & REDIRECT line pointers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: Create index on foreign table