Re: Vacuum/visibility is busted

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es

From: Alvaro Herrera <alvherre@2ndquadrant.com>

To: Pavan Deolasee <pavan.deolasee@gmail.com>

Cc: Jeff Janes <jeff.janes@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2013-02-08T04:38:18Z

Lists: pgsql-hackers

Attachments

fix-freeze.patch (text/x-diff) patch

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.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services