Re: freezing multixacts

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: freezing multixacts
Дата
Msg-id CA+U5nMJudDzPQZ=9tRKvvVZYuWm8UnxO_VNF9=tJYRp=8LeoXA@mail.gmail.com
обсуждение исходный текст
Ответ на freezing multixacts  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
On Thu, Feb 2, 2012 at 4:33 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:

> However, there are cases where not even that is possible -- consider
> tuple freezing during WAL recovery.  Recovery is going to need to
> replace those multis with other multis, but it cannot create new multis
> itself.  The only solution here appears to be that when multis are
> frozen in the master, replacement multis have to be logged too.  So the
> heap_freeze_tuple Xlog record will have a map of old multi to new.  That
> way, recovery can just determine the new multi to use for any particular
> old multi; since multixact creation is also logged, we're certain that
> the replacement value has already been defined.

Multixacts are ignored during recovery. Why do anything at all?

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Dry-run mode for pg_archivecleanup
Следующее
От: Robert Haas
Дата:
Сообщение: Re: freezing multixacts