Re: Freezing is not WAL-logged

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Freezing is not WAL-logged
Дата
Msg-id 20061019192204.GC16965@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Freezing is not WAL-logged  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Freezing is not WAL-logged  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-bugs
Tom Lane wrote:
> "Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> > I just noticed that freezing a tuple (in vacuumlazy.c) is not
> > WAL-logged.
>
> The theory is that this doesn't matter because the tuple is committed
> either way ... it's equivalent to a hint-bit update which we don't
> WAL-log either.

Also it'd be hugely expensive to log each freeze operation.  The
alternative would be to log a VACUUM FREEZE, but that has the potential
to cause enormous recovery runtime.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Freezing is not WAL-logged
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Freezing is not WAL-logged