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 AB9FD5E46CE for ; Fri, 13 Aug 2004 19:18:37 -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 99798-10 for ; Fri, 13 Aug 2004 22:18:29 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 9C4835E46C4 for ; Fri, 13 Aug 2004 19:18:27 -0300 (ADT) Received: from [64.81.245.111] (HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6072709; Fri, 13 Aug 2004 15:19:41 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "borajetta" , Subject: Re: REINDEX needed because of index corruption need help ASAP Date: Fri, 13 Aug 2004 15:18:41 -0700 User-Agent: KMail/1.5.4 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200408131518.41992.josh@agliodbs.com> 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/222 X-Sequence-Number: 7858 Aaron, > We are getting this error for other index's including primary key indexs where we get OID page not found errors and the index corruption as posted above. > Sometimes when the index is broken it will cause run away searches which eat up all the memory and the server needs to be restarted. What version of PostgreSQL are you using? Do you have frequent power-outs on the machine? Have you tested for bad hard drive, controller, or memory? Corruption of any kind on PostgreSQL is not normal. It's usually indicative of a hardware problem. -- -Josh Berkus "A developer of Very Little Brain" Aglio Database Solutions San Francisco