Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
> I'm not sure whether this is related to the stats collector problems
> on this machine, but I noticed alarming table bloat in the catalog
> tables pg_attribute, pg_attrdef, pg_depend, and pg_type.
Hmm. That makes me wonder if autovacuum is functioning properly at all.
What does pg_stat_all_tables show for the last vacuum and analyze times
of those tables? Try something like
select relname,n_live_tup,n_dead_tup,last_vacuum,last_autovacuum,last_analyze,last_autoanalyze from pg_stat_all_tables where schemaname = 'pg_catalog' order by 1;
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2010-04-16 15:29:47|
|Subject: Re: stats collector suddenly causing lots of IO |
|Previous:||From: Josh Kupershmidt||Date: 2010-04-16 14:39:07|
|Subject: Re: stats collector suddenly causing lots of IO|