On Mon, Aug 17, 2009 at 6:17 PM, Tom Lane<tgl@xxxxxxxxxxxxx> wrote: > Hm, what's your current XID counter? (pg_controldata would give an > approximate answer.) I'm wondering if the xmax's are marked committed > but are in the future ... > FWIW that doesn't look right. That would result in HeapTupleBeingUpdated. The only case where it could result in "invisible" is if it's our own xid. Excluding the cases where our own xid is in the tuple I think the relevant cases are either xmin aborted or in progress (or in future) MOVED_OFF and xvac committed MOVED_IN and xvac aborted or is in progress (or in future) -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general