Re: serious issue with age(relfrozenxid)::int.

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: serious issue with age(relfrozenxid)::int.
Дата
Msg-id
6699.1405870106@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
serious issue with age(relfrozenxid)::int. Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>
Re: serious issue with age(relfrozenxid)::int. John R Pierce <pierce@hogranch.com>
Re: serious issue with age(relfrozenxid)::int. Adrian Klaver <adrian.klaver@aklaver.com>
Re: serious issue with age(relfrozenxid)::int. Tom Lane <tgl@sss.pgh.pa.us>
Prabhjot Sheena  writes:
>           Most of my tables in postgresql database 8.3 is showing up this.
> Pls suggest me what should be done with this and if this is something
> really serious

There's no reason to think that this means anything at all.  You did not
bother to filter by relkind, so most likely those MAXINT results
correspond to entries that have relfrozenxid = 0 because the system
doesn't track relfrozenxid for them (eg, indexes).

			regards, tom lane

В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Tom Lane
Дата:
Сообщение: Re: check database integrity
FAQ