Re: Toast issues with OldestXmin going backwards

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Toast issues with OldestXmin going backwards
Дата
Msg-id 87tvrxa210.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Toast issues with OldestXmin going backwards  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
>>>>> "Robert" == Robert Haas <robertmhaas@gmail.com> writes:

 Robert> I wonder if perhaps get_actual_variable_range() has a hazard of
 Robert> this type as well. If OldestXmin retreats, then the special
 Robert> snapshot type which it uses could see a row whose TOAST entry
 Robert> has been removed meanwhile.

Actually get_actual_variable_range may have a hazard even if OldestXmin
does not retreat; it uses RecentGlobalXmin, which is quite likely to be
older than an OldestXmin value used by a vacuum.

-- 
Andrew (irc:RhodiumToad)

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Toast issues with OldestXmin going backwards
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS