Postgres Pro
Downloads
Home   >   mailing lists

Re: page is uninitialized? - Mailing list pgsql-general

From Tom Lane
Subject Re: page is uninitialized?
Date
Msg-id 26215.1145458931@sss.pgh.pa.us
Whole thread Raw
In response to page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Responses Re: page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-general
Tree view 
Brendan Duddridge <brendan@clickspace.com> writes:
> I was doing a vacuum analyze verbose on my database today and I
> noticed the following message printed out:

> WARNING:  relation "category_product" page 128979 is uninitialized
> --- fixing
> WARNING:  relation "category_product" page 128980 is uninitialized
> --- fixing
> ...

There are some situations in which this is expected, which is why
VACUUM deals with it, but none of them are very good: they involve
backends adding a page to a table and then failing before they can
write a WAL record about initializing the page.  Have you had any
crashes recently?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: page is uninitialized?
Next
From: Alban Hertroys
Date:
Subject: Re: Categories and Sub Categories (Nested)