"xmin" system column

From: "Eric B(dot) Ridge" <ebr(at)tcdi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "xmin" system column
Date: 2006-01-26 21:19:34
Message-ID: B5FBE2A8-7D5A-4810-AD66-5C7D8A1F8B42@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-01-26 21:41:32 Re: VACUUM Question
Previous Message Chris Browne 2006-01-26 21:14:45 Re: VACUUM Question