Re: ERROR: XX001 (Critical and Urgent)

[Siddharth Shah <siddharth.shah@xxxxxxxxxxxxx>]

Kevin Grittner wrote:

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

Kevin, It start normally , I have successfully retrieved data from few tables
But I am not able to do dS / dT or dt. As you said this is index file for Postgres tables and indexes
Now when I taken call for reindex   pg_class_relname_nsp_index it takes 99% CPU

  PID  PPID USER     STAT   VSZ %MEM %CPU COMMAND
13419 13418 nobody   R    39172   8%  99% postgres --single -P -D /var/db -p 5433 xdb
It's been running from 10 minutes still there is no output or logs.