Re: ERROR: XX001 (Critical and Urgent)

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Siddharth Shah" <siddharth(dot)shah(at)elitecore(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: XX001 (Critical and Urgent)
Date: 2010-05-07 15:21:46
Message-ID: 4BE3E9BA0200002500031394@gw.wicourts.gov
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

Siddharth Shah <siddharth(dot)shah(at)elitecore(dot)com> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Spiegelberg 2010-05-07 15:35:54 Re: postgres invoked oom-killer
Previous Message Lacey Powers 2010-05-07 15:15:14 Re: postgres invoked oom-killer

Browse pgsql-novice by date

  From Date Subject
Next Message Siddharth Shah 2010-05-07 15:42:15 Re: ERROR: XX001 (Critical and Urgent)
Previous Message Atif Jung 2010-05-07 15:11:54 PREPARE statement