Re: Record not returned until index is rebuilt - Mailing list pgsql-general

From Nik
Subject Re: Record not returned until index is rebuilt
Date
Msg-id 1170081505.642681.105750@m58g2000cwm.googlegroups.com
Whole thread Raw
In response to Re: Record not returned until index is rebuilt  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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...@sss.pgh.pa.us (Tom Lane) wrote:
> "Nik" <XLPi...@gmail.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


pgsql-general by date:

Previous
From: "shakahshakah@gmail.com"
Date:
Subject: Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Next
From: "Timasmith"
Date:
Subject: SQL to get a table columns comments?