Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Thu, Aug 02, 2007 at 10:40:24PM -0400, Joseph S wrote:
>> I do use autovac. Like I said they don't get really out of hand, only
>> up to 20 megs or so before I noticed that it was weird. The large
>> indexes are what tipped me off that something str
On Thu, Aug 02, 2007 at 10:40:24PM -0400, Joseph S wrote:
> Tom Lane wrote:
> >Heavy use of temp tables would expand pg_class, pg_type, and especially
> >pg_attribute, but as long as you have a decent vacuuming regimen (do you
> >use autovac?) they shouldn't get out of hand.
>
> I do use autovac.
Joseph S <[EMAIL PROTECTED]> writes:
> ... and when I notice that the tuplesperpage for the indexes is low (or
> that the indexes are bigger then the tables themselves) I know it is
> time for a VACUUM FULL and REINDEX on that table.
If you are taking the latter as a blind must-be-wrong conditio
Tom Lane wrote:
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
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
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
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
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
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 c
