Re: reindexing pg_shdepend - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: reindexing pg_shdepend
Date
Msg-id 20070802214149.GC6203@alvh.no-ip.org
Whole thread Raw
In response to reindexing pg_shdepend  (Joseph S <jks@selectacast.net>)
List pgsql-general
Joseph S wrote:
> 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?

Nope :-(

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Joseph S
Date:
Subject: reindexing pg_shdepend
Next
From: Ron Mayer
Date:
Subject: Re: Linux distro