Re: tuptoaster.c must *not* use SnapshotAny

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: tuptoaster.c must *not* use SnapshotAny
Дата
Msg-id
23314.1011277356@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
tuptoaster.c must *not* use SnapshotAny Tom Lane <tgl@sss.pgh.pa.us>
Re: tuptoaster.c must *not* use SnapshotAny Jan Wieck <janwieck@yahoo.com>
Re: tuptoaster.c must *not* use SnapshotAny Tom Lane <tgl@sss.pgh.pa.us>
Re: tuptoaster.c must *not* use SnapshotAny "Command Prompt, Inc." <pgsql-hackers@commandprompt.com>
Re: tuptoaster.c must *not* use SnapshotAny Tom Lane <tgl@sss.pgh.pa.us>
"Zeugswetter Andreas SB SD"  writes:
>> It doesn't matter whether it's FrozenXid or not.  The tuple is not
>> visible if it's got the wrong setting of HEAP_MOVED_OFF/IN.

> But the FrozenXid tuple has HEAP_MOVED_IN and the original has
> not yet been altered to HEAP_MOVED_OFF because of abort.
> Is the HEAP_MOVED_IN tuple not visible ?

Right.  Actually it doesn't matter whether the old tuple has
HEAP_MOVED_OFF or not; it's still visible *until* the VACUUM commits.
The commit atomically switches us from the state where the unmoved
tuples are good to the state where the moved ones are good.

This is all exactly the same whether FrozenXid is involved or not.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Gavin Sherry
Дата:
Сообщение: can't shrink relation
FAQ