Re: Record not returned until index is rebuilt

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(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> "Nik" <XLPi(dot)(dot)(dot)(at)gmail(dot)com> 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