Re: Toast issues with OldestXmin going backwards

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Toast issues with OldestXmin going backwards
Дата
Msg-id 25213.1524769741@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Toast issues with OldestXmin going backwards  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Toast issues with OldestXmin going backwards  (Michael Paquier <michael@paquier.xyz>)
Re: Toast issues with OldestXmin going backwards  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I wonder if perhaps get_actual_variable_range() has a hazard of this
> type as well.  If OldestXmin retreats, then the special snapshot type
> which it uses could see a row whose TOAST entry has been removed
> meanwhile.

Hm, yeah.  I wonder if we could fix that by extracting the value from
the index rather than recomputing it from the heap tuple, as we do now.
We'd still have to visit the heap tuple to check liveness, but we'd
not need to extract anything from its data part.

Have we given up on the angle of "prevent OldestXmin from retreating"?
That seems like it'd be far more bulletproof than trying to work
around places that break one-by-one.

            regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Moving relation extension locks out of heavyweightlock manager