reindexing pg_shdepend

From: Joseph S <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: reindexing pg_shdepend
Date: 2007-08-02 21:00:16
Message-ID: f8tgkk$2vp5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My pg_shdepend table has a size of 16,384, but
pg_shdepend_depender_index has a size of 19,169,280 and
pg_shdepend_reference_index has a size of 49,152. When I try to reindex
the table I get:

ERROR: shared table "pg_shdepend" can only be reindexed in stand-alone mode

So is there any way I can clear this bloat w/o restarting the server?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pritchard.adam 2007-08-02 21:33:50 ORDER BY on multiple columns still requires multi-col index?
Previous Message Dave Page 2007-08-02 20:40:03 Re: pgTray - win32 tray tool for monitoring PostgreSQL service