Re: Vacuum/visibility is busted

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Vacuum/visibility is busted
Дата
Msg-id CAMkU=1wJnGgkswCHMdykFYScEO_8NNb+if4LCgiW+Jtv+UpVEw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum/visibility is busted  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Feb 7, 2013 at 8:38 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Alvaro Herrera escribió:
>> Alvaro Herrera escribió:
>>
>> > Hm, if the foreign key patch is to blame, this sounds like these tuples
>> > had a different set of XMAX hint bits and a different Xmax, and they
>> > were clobbered by something like vacuum or page pruning.
>>
>> Hm, I think heap_freeze_tuple is busted, yes.
>
> This patch seems to fix the problem for me.  Please confirm.

Applied to 0ac5ad5134f276, it has survived 4 wrap-arounds so far
without problem.  I will let it go for a while longer, but I think we
can assume it is fixed.

Cheers,

Jeff



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Too frequent checkpoints ?
Следующее
От: Tom Lane
Дата:
Сообщение: DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?)