Re: ERROR: XX001 (Critical and Urgent)

Siddharth Shah <siddharth.shah@elitecore.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