X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 419615E37D0 for ; Fri, 13 Aug 2004 19:25:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02951-08 for ; Fri, 13 Aug 2004 22:25:13 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 5BA2D5E37CB for ; Fri, 13 Aug 2004 19:25:12 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7DMNxQS027756; Fri, 13 Aug 2004 18:23:59 -0400 (EDT) To: "borajetta" Cc: pgsql-performance@postgresql.org Subject: Re: REINDEX needed because of index corruption need help ASAP In-reply-to: References: Comments: In-reply-to "borajetta" message dated "Fri, 13 Aug 2004 14:40:26 -0700" Date: Fri, 13 Aug 2004 18:23:59 -0400 Message-ID: <27755.1092435839@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/221 X-Sequence-Number: 7857 "borajetta" 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