Re: [GENERAL] reindexing pg_shdepend

2007-08-02 Thread Joseph S
Me too. I don't change my db schema that much, but I experience bloat in the pg_tables that I don't expect. For instance pg_opclass needs a VACUUM FULL/REINDEX once a week or I notice the indexes are larger than the table itself. Could it be my heavy use of temp tables? Today I noticed that

Re: [GENERAL] reindexing pg_shdepend

2007-08-02 Thread Tom Lane
Joseph S <[EMAIL PROTECTED]> writes: > Me too. I don't change my db schema that much, but I experience bloat > in the pg_tables that I don't expect. For instance pg_opclass needs a > VACUUM FULL/REINDEX once a week or I notice the indexes are larger than > the table itself. Could it be my hea

Re: [GENERAL] reindexing pg_shdepend

2007-08-02 Thread Tom Lane
Joseph S <[EMAIL PROTECTED]> writes: > 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. I'd be interested to see the usage pattern that made it get like that ... r

Re: [GENERAL] reindexing pg_shdepend

2007-08-02 Thread Alvaro Herrera
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 > mod