Thanks for the quick response. It is PostgreSQL 8.0.6 running on Windows 2003 Server. I haven't had any other issues with this particular piece of hardware and it is fairly new and well maintained (not that this matters much). I am going to try to drop and recreate this table, index, and the contents and see if I face any other problems. Nik On Jan 26, 4:26 pm, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > "Nik" <XLPi...@xxxxxxxxx> writes: > > I have the following table definition in postgres 8.0:PG 8.0.what, exactly? > > > Why is it that therecordis visible when bulk selected, butnotwhen > > 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'renotall 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster
