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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Excuting SQL-Statements after error in same transaction ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: libpq.so