Re: Vacuum/visibility is busted - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Vacuum/visibility is busted
Date
Msg-id CAMkU=1wJnGgkswCHMdykFYScEO_8NNb+if4LCgiW+Jtv+UpVEw@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum/visibility is busted  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Too frequent checkpoints ?
Next
From: Tom Lane
Date:
Subject: DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?)