"xmin" system column
От | Eric B. Ridge |
---|---|
Тема | "xmin" system column |
Дата | |
Msg-id | B5FBE2A8-7D5A-4810-AD66-5C7D8A1F8B42@tcdi.com обсуждение исходный текст |
Ответы |
Re: "xmin" system column
Re: "xmin" system column Re: "xmin" system column |
Список | 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 по дате отправления: