"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