Re: [PERFORM] Dump performance problems following server crash

2006-12-02 Thread Kim
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 <[EMAIL PROTECTED]> writes: The current dump query running: SELECT t.tableoid, t.oid, t.relname as indexname

Re: [PERFORM] Dump performance problems following server crash

2006-12-02 Thread Tom Lane
Kim <[EMAIL PROTECTED]> 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,

[PERFORM] Dump performance problems following server crash

2006-12-02 Thread Kim
Hello Performance, Yesterday, with help from the admin list, we took care of a problem we were having with creating tables/views/indexes following a server overheat & crash (an index on pg_attribute was corrupted, causing the create to hang and go through the roof on memory usage until it fail