Search Postgresql Archives

Re: page is uninitialized?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Brendan Duddridge <brendan@xxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux