Re: GetOldestXmin going backwards is dangerous after all

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GetOldestXmin going backwards is dangerous after all
Дата
Msg-id 566.1359996725@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GetOldestXmin going backwards is dangerous after all  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: GetOldestXmin going backwards is dangerous after all  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> I absolutely hate to suggest it, but what about storing the last
> vacuum's xmin horizon in the main table's pg_class.options in the back
> branches?

Not workable.  This would require a non-in-place update of the table's
pg_class row (at least in cases where the option wasn't stored already).
Which would require VACUUM to have an XID, which would make a whole lot
of assumptions fall over.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: GetOldestXmin going backwards is dangerous after all
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: sql_drop Event Trigger