Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 4A71863381B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  7 May 2010 12:43:42 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 49067-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  7 May 2010 15:43:34 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from elitecore.com (mailhost.elitecore.com [203.88.135.194])
	by mail.postgresql.org (Postfix) with ESMTP id E77E163381D
	for <pgsql-admin@postgresql.org>; Fri,  7 May 2010 12:43:33 -0300 (ADT)
Received: (qmail 14410 invoked from network); 7 May 2010 15:43:31 -0000
Received: from router.elitecore.com (HELO [192.168.1.136])
	(siddharth.shah@[203.88.135.193])
	(envelope-sender <siddharth.shah@elitecore.com>)
	by elitecore.com (qmail-ldap-1.03) with SMTP
	for <Kevin.Grittner@wicourts.gov>; 7 May 2010 15:43:31 -0000
Message-ID: <4BE434D7.4050205@elitecore.com>
Date: Fri, 07 May 2010 21:12:15 +0530
From: Siddharth Shah <siddharth.shah@elitecore.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: pgsql-admin@postgresql.org
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>
	<4BE3E9BA0200002500031394@gw.wicourts.gov>
In-Reply-To: <4BE3E9BA0200002500031394@gw.wicourts.gov>
Content-Type: multipart/alternative;
	boundary="------------000706090009010603040401"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201005/101
X-Sequence-Number: 34574

This is a multi-part message in MIME format.
--------------000706090009010603040401
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------000706090009010603040401
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Kevin Grittner wrote:
<blockquote cite="mid4BE3E9BA0200002500031394@gw.wicourts.gov"
 type="cite">
  <pre wrap="">Siddharth Shah <a class="moz-txt-link-rfc2396E" href="mailto:siddharth.shah@elitecore.com">&lt;siddharth.shah@elitecore.com&gt;</a> wrote:
 
  </pre>
  <blockquote type="cite">
    <blockquote type="cite">
      <blockquote type="cite">
        <pre wrap="">xdb=# reindex index pg_class_relname_nsp_index;

Now INDEXing taking High CPU and postgres baffled.
        </pre>
      </blockquote>
    </blockquote>
  </blockquote>
  <pre wrap=""><!----> 
  </pre>
  <blockquote type="cite">
    <blockquote type="cite">
      <pre wrap="">consider doing your recovery in single-user mode
      </pre>
    </blockquote>
  </blockquote>
  <pre wrap=""><!----> 
  </pre>
  <blockquote type="cite">
    <pre wrap="">    postgres --single -P -D $DATADIR -p 5433 xdb
    Same behavior in single mode.
    </pre>
  </blockquote>
  <pre wrap=""><!----> 
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
  </pre>
</blockquote>
<br>
Kevin, It start normally , I have successfully retrieved data from few
tables<br>
But I am not able to do dS / dT or dt. As you said this is index file
for Postgres tables and indexes<br>
Now when I taken call for reindex&nbsp;&nbsp; pg_class_relname_nsp_index it takes
99% CPU<br>
<br>
&nbsp; PID&nbsp; PPID USER&nbsp;&nbsp;&nbsp;&nbsp; STAT&nbsp;&nbsp; VSZ %MEM %CPU COMMAND<br>
13419 13418 nobody&nbsp;&nbsp; R&nbsp;&nbsp;&nbsp; 39172&nbsp;&nbsp; 8%&nbsp; 99% postgres --single -P -D
/var/db -p 5433 xdb <br>
It's been running from 10 minutes still there is no output or logs.<br>
<br>
<pre wrap="">
</pre>
</body>
</html>

--------------000706090009010603040401--