Re: Per-table freeze limit proposal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Per-table freeze limit proposal
Дата
Msg-id 15865.1126812656@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Per-table freeze limit proposal  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Cool.  I wonder if the exact figure should be
> min(lowest non-frozen Xid in table, GetOldestXmin(false))

Actually just min(lowest Xid in table, RecentXmin).  You only need to be
sure there are no running transactions older than what you put into the
field; their xmins are not at issue.

> Also, in light of this, it seems a bad idea to use the name "freezexid"
> for the pg_class column; I would name it relminxid or something like
> that (suggestions welcome).

Works for me.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: pg_autovacuum settings not saved on dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_autovacuum settings not saved on dump