Re: REINDEX needed because of index corruption need help ASAP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "borajetta" <borajetta(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: REINDEX needed because of index corruption need help ASAP
Date: 2004-08-13 22:23:59
Message-ID: 27755.1092435839@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"borajetta" <borajetta(at)hotmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Cheston 2004-08-14 01:27:04 Replication: Slony-I vs. Mammoth Replicator vs. ?
Previous Message Josh Berkus 2004-08-13 22:18:41 Re: REINDEX needed because of index corruption need help ASAP