Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Дата
Msg-id 4D75EAC4.7090008@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum  (daveg <daveg@sonic.net>)
Список pgsql-hackers
On 08.03.2011 10:00, Heikki Linnakangas wrote:
> Another idea is to give up on the warning when it appears that
> oldestxmin has moved backwards, and assume that it's actually fine. We
> could still warn in other cases where the flag appears to be incorrectly
> set, like if there is a deleted tuple on the page.

This is probably a better idea at least in back-branches. It also
handles the case of twiddling vacuum_defer_cleanup_age, which tracking
two xmins per transactions would not handle.

Here's a patch. I also changed the warning per Robert's suggestion.
Anyone see a hole in this?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Theory of operation of collation patch
Следующее
От: daveg
Дата:
Сообщение: Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum