"Nik" <XLPizza@xxxxxxxxx> 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
