Re: Freezing is not WAL-logged

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Freezing is not WAL-logged
Дата
Msg-id 4537E03F.9060606@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Freezing is not WAL-logged  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.

Because the relminxid-update is WAL-logged, you can get into situation
where relminxid > the real smallest xid of the table, as demonstrated by
the example I gave. relminxid is used to determine the safe clog cut-off
point, so that's not harmless.

Granted, the chances of getting data corruption from this are small, but
it's possible.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Freezing is not WAL-logged
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: hello