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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
