Re: VACUUM warning message. - Mailing list pgsql-admin

From Tom Lane
Subject Re: VACUUM warning message.
Date
Msg-id 8369.1043704339@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM warning message.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: VACUUM warning message.  (<mallah@trade-india.com>)
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I assume this is 7.2.X.  I know this is fixed in 7.3.1 but I am not sure
> what release we fixed it in.  The HISTORY file doesn't have a specific
> mention of the fix.  It is not something to be worried about, as I
> remember.

Mmm, I'm not sure.  The known variant of this problem only affects certain
system tables (the nailed-in-cache ones):
http://archives.postgresql.org/pgsql-hackers/2002-11/msg00486.php

This is evidently a user table:

> WARNING:  Rel site_search: Uninitialized page 1 - fixing

I'd wonder about hardware failures, myself.  Does the table appear
to have lost a lot of rows that should have been there?

Other interesting questions are whether the table has recently undergone
a TRUNCATE, or deletion of a large fraction of its rows followed by
VACUUM (probably VACUUM FULL).

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot connect to the database (PG 7.3)
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication