Re: Bug: Unreferenced temp tables disables vacuum to update xid

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug: Unreferenced temp tables disables vacuum to update xid
Дата
Msg-id 8672.1200354499@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug: Unreferenced temp tables disables vacuum to update xid  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Perhaps what we could do is take the relfrozenxid from the old relation
> and copy it over, if it's later than FreezeXid?

It certainly doesn't seem to make any sense to allow the rel's
relfrozenxid to go backwards.  Indeed this coding lets it end up less
than the DB's datfrozenxid, which is certainly inappropriate.

What might be the best idea is to advance FreezeXid to the old
relfrozenxid between the vacuum_set_xid_limits and begin_heap_rewrite
calls.  Then we'd be quite certain we are not lying: anything older
than that did indeed get frozen.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Bug: Unreferenced temp tables disables vacuum to update xid
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql Materialized views