Re: page x is unitialized

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: page x is unitialized
Дата
Msg-id 20651.1087571855@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: page x is unitialized  (Michael Guerin <guerin@rentec.com>)
Список pgsql-novice
Michael Guerin <guerin@rentec.com> writes:
> Tom Lane wrote:
>> It's not good.  The least bad explanation is that you had a system crash
>> recently that occurred between extending a table by one page and filling
>> that page with useful data.  (The page is filled with zeroes on creation.)

> Could this lead to the invalid page header problems that I've been
> having lately?

No, more the other way around.  IIRC, "page n is uninitialized" is
VACUUM's report that it is fixing an invalid page header.

            regards, tom lane

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