Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 79B6F9FA16F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat,  2 Dec 2006 13:29:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 84489-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat,  2 Dec 2006 13:29:25 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from myemma.com (db1.e2ma.net [66.179.147.163])
	by postgresql.org (Postfix) with ESMTP id 4E65D9F938C
	for <pgsql-performance@postgresql.org>;
	Sat,  2 Dec 2006 13:29:32 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by myemma.com (Postfix) with ESMTP id A590F23CD8;
	Sat,  2 Dec 2006 11:29:31 -0600 (CST)
Received: from myemma.com ([127.0.0.1])
	by localhost (velma [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
	id 30591-05; Sat, 2 Dec 2006 11:29:30 -0600 (CST)
Received: from [192.168.1.113] (c-68-53-86-247.hsd1.tn.comcast.net
	[68.53.86.247]) by myemma.com (Postfix) with ESMTP id E5BF223CD2;
	Sat,  2 Dec 2006 11:29:29 -0600 (CST)
Message-ID: <4571B7FA.4070002@myemma.com>
Date: Sat, 02 Dec 2006 11:29:30 -0600
From: Kim <kim@myemma.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Dump performance problems following server crash
References: <4571A0BC.8020503@myemma.com> <21380.1165079632@sss.pgh.pa.us>
In-Reply-To: <21380.1165079632@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------040008010101000309070804"
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at myemma.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.631 tagged_above=0 required=5 tests=AWL, BAYES_50,
	FORGED_RCVD_HELO, HTML_30_40, HTML_MESSAGE, SPF_HELO_PASS, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200612/12
X-Sequence-Number: 22068

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

We dropped into single user mode and ran reindex system - it was my 
understanding this would reindex them all, including shared catalogs - 
but perhaps not?

Kim

Tom Lane wrote:

>Kim <kim@myemma.com> writes:
>  
>
>>The current dump query running:
>>SELECT t.tableoid, t.oid, t.relname as indexname, 
>>pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, t.relnatts as 
>>indnkeys, i.indkey, i.indisclustered, c.contype, c.conname, c.tableoid 
>>as contableoid, c.oid as conoid, (SELECT spcname FROM 
>>pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) as tablespace 
>>FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = 
>>i.indexrelid) LEFT JOIN pg_catalog.pg_depend d ON (d.classid = 
>>t.tableoid AND d.objid = t.oid AND d.deptype = 'i') LEFT JOIN 
>>pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid 
>>= c.oid) WHERE i.indrelid = '44240'::pg_catalog.oid ORDER BY indexname
>>    
>>
>
>  
>
>>Amount of time it took me to run the query from console: ~5secs (I'm 
>>counting in my head, sophisticated, eh?)
>>    
>>
>
>Even 5 seconds is way too long.  You've apparently still got something
>corrupted somewhere.  Did you reindex *all* the system catalogs?
>
>			regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>  
>

-- 

*kim hatcher*
senior developer, emmaŽ
e: kim@myemma.com <mailto:kim@myemma.com>
p: 800 595 4401
w: www.myemma.com <http://www.myemma.com>

--------------040008010101000309070804
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">
</head>
<body bgcolor="#ffffff" text="#000000">
We dropped into single user mode and ran reindex system - it was my
understanding this would reindex them all, including shared catalogs -
but perhaps not? <br>
<br>
Kim<br>
<br>
Tom Lane wrote:
<blockquote cite="mid21380.1165079632@sss.pgh.pa.us" type="cite">
  <pre wrap="">Kim <a class="moz-txt-link-rfc2396E" href="mailto:kim@myemma.com">&lt;kim@myemma.com&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">The current dump query running:
SELECT t.tableoid, t.oid, t.relname as indexname, 
pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, t.relnatts as 
indnkeys, i.indkey, i.indisclustered, c.contype, c.conname, c.tableoid 
as contableoid, c.oid as conoid, (SELECT spcname FROM 
pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) as tablespace 
FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = 
i.indexrelid) LEFT JOIN pg_catalog.pg_depend d ON (d.classid = 
t.tableoid AND d.objid = t.oid AND d.deptype = 'i') LEFT JOIN 
pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid 
= c.oid) WHERE i.indrelid = '44240'::pg_catalog.oid ORDER BY indexname
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
  <blockquote type="cite">
    <pre wrap="">Amount of time it took me to run the query from console: ~5secs (I'm 
counting in my head, sophisticated, eh?)
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Even 5 seconds is way too long.  You've apparently still got something
corrupted somewhere.  Did you reindex *all* the system catalogs?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

  </pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<br>
<font color="#339933" face="Verdana" size="1"><b>kim hatcher</b></font><br>
<font color="#838881" face="Verdana" size="1">
senior developer, emma&reg;<br>
e: <a href="mailto:kim@myemma.com">kim@myemma.com</a><br>
p: 800 595 4401<br>
w: <a href="http://www.myemma.com">www.myemma.com</a><br>
</font>
</div>
</body>
</html>

--------------040008010101000309070804--