From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Kupershmidt <schmiddy@gmail.com>
Cc: Chris <lists@deksai.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: stats collector suddenly causing lots of IO
Date: Fri, 16 Apr 2010 11:41:24 -0400
Message-ID: <10082.1271432484@sss.pgh.pa.us> (raw)
In-Reply-To: <g2t4ec1cf761004160830q5dff4315rcc0294d342999c35@mail.gmail.com>
References: <20100413170105.GA29571@chris-laptop.a2hosting.com>
<25952.1271370711@sss.pgh.pa.us>
<z2s4ec1cf761004160739w3ac5511jd39263dd043e2da6@mail.gmail.com>
<9738.1271431432@sss.pgh.pa.us>
<g2t4ec1cf761004160830q5dff4315rcc0294d342999c35@mail.gmail.com>
Josh Kupershmidt <schmiddy@gmail.com> writes:
> On Fri, Apr 16, 2010 at 11:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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;
> Output attached. Note that I ran pg_stat_reset() a few days ago.
Wow. Well, we have a smoking gun here: for some reason, autovacuum
isn't running, or isn't doing its job if it is. If it's not running
at all, that would explain failure to prune the stats collector's file
too.
Is there anything in the postmaster log that would suggest autovac
difficulties?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, schmiddy@gmail.com, lists@deksai.com
Subject: Re: stats collector suddenly causing lots of IO
In-Reply-To: <10082.1271432484@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox