From: Kim <kim@myemma.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Dump performance problems following server crash
Date: Sat, 02 Dec 2006 11:29:30 -0600
Message-ID: <4571B7FA.4070002@myemma.com> (raw)
In-Reply-To: <21380.1165079632@sss.pgh.pa.us>
References: <4571A0BC.8020503@myemma.com>
<21380.1165079632@sss.pgh.pa.us>
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;
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-performance@postgresql.org
Cc: kim@myemma.com, tgl@sss.pgh.pa.us
Subject: Re: Dump performance problems following server crash
In-Reply-To: <4571B7FA.4070002@myemma.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