Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5BA5A632A8D for ; Fri, 7 May 2010 12:21:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 10663-06 for ; Fri, 7 May 2010 15:21:51 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 788B5632545 for ; Fri, 7 May 2010 12:21:51 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Fri, 07 May 2010 10:21:50 -0500 Message-Id: <4BE3E9BA0200002500031394@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Fri, 07 May 2010 10:21:46 -0500 From: "Kevin Grittner" To: "Siddharth Shah" Cc: Subject: Re: ERROR: XX001 (Critical and Urgent) References: <4BE3C93C.70800@elitecore.com> <4BE3D0EF020000250003137D@gw.wicourts.gov> <4BE41AE1.4010804@elitecore.com> <4BE3DB1D020000250003138A@gw.wicourts.gov> <4BE42B16.8060804@elitecore.com> In-Reply-To: <4BE42B16.8060804@elitecore.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/98 X-Sequence-Number: 34571 Siddharth Shah wrote: >>> xdb=# reindex index pg_class_relname_nsp_index; >>> >>> Now INDEXing taking High CPU and postgres baffled. >> consider doing your recovery in single-user mode > postgres --single -P -D $DATADIR -p 5433 xdb > Same behavior in single mode. How long did you leave it running? Did you get any messages? Is there anything in the log? What do CPU usage and disk usage look like during the attempt? -Kevin