Re: reindexing pg_shdepend

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Joseph S <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: reindexing pg_shdepend
Date: 2007-08-02 21:41:49
Message-ID: 20070802214149.GC6203@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2007-08-03 00:21:05 Re: Linux distro
Previous Message pritchard.adam 2007-08-02 21:33:50 ORDER BY on multiple columns still requires multi-col index?