Re: heap errors - should I be worried?

Ulrich Wisser <ulrich.wisser@relevanttraffic.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