Re: REINDEX needed because of index corruption need help ASAP - Mailing list pgsql-performance

From Tom Lane
Subject Re: REINDEX needed because of index corruption need help ASAP
Date
Msg-id 27755.1092435839@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX needed because of index corruption need help ASAP  ("borajetta" <borajetta@hotmail.com>)
List pgsql-performance
"borajetta" <borajetta@hotmail.com> writes:
> We are getting this error for other index's including primary key indexs wh=
> ere we get OID page not found errors and the index corruption as posted abo=
> ve.
> Sometimes when the index is broken it will cause run away searches which ea=
> t up all the memory and the server needs to be restarted.

It sounds to me like you have got hardware problems.  Get out your
memory and disk tests ...

            regards, tom lane

pgsql-performance by date:

Previous
From: "borajetta"
Date:
Subject: REINDEX needed because of index corruption need help ASAP
Next
From: Josh Berkus
Date:
Subject: Re: REINDEX needed because of index corruption need help ASAP