reindexing pg_shdepend - Mailing list pgsql-general

From Joseph S
Subject reindexing pg_shdepend
Date
Msg-id f8tgkk$2vp5$1@news.hub.org
Whole thread Raw
Responses Re: reindexing pg_shdepend  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: reindexing pg_shdepend  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?

pgsql-general by date:

Previous
From: Jon Lapham
Date:
Subject: Re: tsearch2 upgrade problem and mediawiki
Next
From: Alvaro Herrera
Date:
Subject: Re: reindexing pg_shdepend