Re: Avoiding Refreezing XIDs Repeatedly

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Avoiding Refreezing XIDs Repeatedly
Дата
Msg-id CAJghg4LziRUuHKhuiqLjW0fuoop6kZA_CSuqx+=ZrU7gyuwKhw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avoiding Refreezing XIDs Repeatedly  (bkrug <bkrug@usatech.com>)
Ответы Re: Avoiding Refreezing XIDs Repeatedly  (bkrug <bkrug@usatech.com>)
Список pgsql-performance
Дерево обсуждения

On Mon, Feb 9, 2015 at 4:45 PM, bkrug <bkrug@usatech.com> wrote:
Should the relfrozenxid of pg_class then equal 2 for very old and already
vacuumed tables? Because that is not what I am seeing.

hm... You meant in the entire table? Like an static table?

Then no, it is done tuple by tuple only. In older versions (I think up to 9.2) it was setting xmin column to 2.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Avoiding Refreezing XIDs Repeatedly
Следующее
От: bkrug
Дата:
Сообщение: Re: Avoiding Refreezing XIDs Repeatedly