"xmin" system column - Mailing list pgsql-general

From Eric B. Ridge
Subject "xmin" system column
Date
Msg-id B5FBE2A8-7D5A-4810-AD66-5C7D8A1F8B42@tcdi.com
Whole thread Raw
Responses Re: "xmin" system column  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: "xmin" system column  (Michael Fuhr <mike@fuhr.org>)
Re: "xmin" system column  (Marko Kreen <markokr@gmail.com>)
List pgsql-general
Outside of "VACUUM FREEZE", is there any way the "xmin" column in a
relation can change, assuming of course the tuple is never updated
again?  I'm considering using this as a way to identify all tuples
modified in the same transaction (in an effort to group them
together), and am wondering if there's any way tuples from different
transactions could end up with the same xmin value.

I've tried both "VACUUM" and "VACUUM FULL" on specific tables and
neither seem to have an impact, but I haven't done extensive testing
against very large tables that have experienced lots of churn.

Any input will be greatly appreciated!

eric

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Arrays
Next
From: Tom Lane
Date:
Subject: Re: VACUUM Question