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,