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
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,
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