Re: heap errors - should I be worried?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: heap errors - should I be worried?
Date: 2004-08-13 13:53:09
Message-ID: 22823.1092405189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> writes:
> WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
> (163) IS NOT THE SAME AS HEAP' (345).
> Recreate the index.

> Should these errors worry me?

Yeah, they should. A REINDEX will probably get you out of the immediate
problem, but the more interesting question is how you got to be missing
index entries in the first place. Have you had any crashes or hardware
problems lately? What PG version is this?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ulrich Wisser 2004-08-13 14:03:18 Re: heap errors - should I be worried?
Previous Message Tom Lane 2004-08-13 13:47:29 Re: REINDEX problem