Re: page x is unitialized - Mailing list pgsql-novice

From Tom Lane
Subject Re: page x is unitialized
Date
Msg-id 20651.1087571855@sss.pgh.pa.us
Whole thread Raw
In response to Re: page x is unitialized  (Michael Guerin <guerin@rentec.com>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Excuting SQL-Statements after error in same transaction ?
Next
From: Tom Lane
Date:
Subject: Re: libpq.so