Re: Record not returned until index is rebuilt

"Nik" <XLPizza@gmail.com> writes:
> I have the following table definition in postgres 8.0:

PG 8.0.what, exactly?

> Why is it that the record is visible when bulk selected, but not when
> selected as a part of the WHERE clause, and why is it that the index
> rebuild and vacuum fixes the problem?

Sounds like a corrupted index.  It seems pretty odd that you would be
getting recurring corruptions like that --- we've recently fixed some
corner case bugs causing index corruption, but they're not all that easy
to trigger (and most of the ones I remember had other symptoms than just
search misses).  How much faith have you got in your hardware platform?

            regards, tom lane