From: Siddharth Shah <siddharth.shah@elitecore.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: ERROR: XX001 (Critical and Urgent)
Date: Fri, 07 May 2010 21:12:15 +0530
Message-ID: <4BE434D7.4050205@elitecore.com> (raw)
In-Reply-To: <4BE3E9BA0200002500031394@gw.wicourts.gov>
References: <4BE3C93C.70800@elitecore.com>
<4BE3D0EF020000250003137D@gw.wicourts.gov>
<4BE41AE1.4010804@elitecore.com>
<4BE3DB1D020000250003138A@gw.wicourts.gov>
<4BE42B16.8060804@elitecore.com>
<4BE3E9BA0200002500031394@gw.wicourts.gov>
Kevin Grittner wrote:
> 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
>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: siddharth.shah@elitecore.com, Kevin.Grittner@wicourts.gov
Subject: Re: ERROR: XX001 (Critical and Urgent)
In-Reply-To: <4BE434D7.4050205@elitecore.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox