"xmin" system column

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

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Arrays
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM Question