Postgres Pro
Downloads
Home   >   mailing lists

page is uninitialized? - Mailing list pgsql-general

From Brendan Duddridge
Subject page is uninitialized?
Date
Msg-id 0ECA8658-AE4C-4DDC-956E-3A36DE351906@clickspace.com
Whole thread Raw
Responses Re: page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Re: page is uninitialized?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi,

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
WARNING:  relation "category_product" page 128981 is uninitialized --- fixing
WARNING:  relation "category_product" page 128982 is uninitialized --- fixing

Could that be due to updates occurring at the same time as vacuuming? There was a heavy process running
at the time that was updating the category_product table.

Thanks,


____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com 

pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: catch SQLException, error code for Foeign key violation,
Next
From: Brendan Duddridge
Date:
Subject: Re: page is uninitialized?