Dirk Lutzebaeck writes:> Tom Lane writes:> > Dirk Lutzebaeck <lutzeb@aeccom.com> writes:> > > cs=> select envelope
fromrecipient where envelope=510349;> > > [ returns a tuple that obviously fails the WHERE condition ]> > > > Yipes.
Do you have an index on the envelope field, and if so is> > it being used for this query? (Use EXPLAIN to check.) My
guess> > is that the index is corrupted. Dropping and recreating the index> > would probably set things right.> >
Yes,thanks, recreating the index cures the problem.
Here is some more info: the automatic vacuum tonight gave the
following errors:
vacuum analyze;
NOTICE: Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
VACUUM
