Re: Multiple table entries? - Mailing list pgsql-general

From Tom Lane
Subject Re: Multiple table entries?
Date
Msg-id 29724.1251050438@sss.pgh.pa.us
Whole thread Raw
In response to Re: Multiple table entries?  (Greg Stark <gsstark@mit.edu>)
Responses Re: Multiple table entries?  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> The last tuple is marked strangely I think. I don't think it's
> supposed to have XMAX_INVALID if xmax is 0 but I could be wrong. Also,
> I don't understand why it's marked as UPDATED if ctid and xmax aren't
> set.

No, that all looks right to me.  UPDATE sets HEAP_UPDATED on the newer
version of the row, not the older one.  What looks interesting to me is
that the last update isn't marked HEAP_ONLY_TUPLE, ie, it's not in the
same HOT chain.  Why is that I wonder ...

> I'm wondering if the page allvisible flag is set. The visibility map
> is one of the few 8.4 patches which impact transaction visibility.

But we don't use that while examining individual tuples, do we?

            regards, tom lane

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Figuring out relationships between tables.
Next
From: Greg Stark
Date:
Subject: Re: Multiple table entries?