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 12:48:48 -0400
Message-ID: <11152.1271436528@sss.pgh.pa.us> (raw)
In-Reply-To: <h2p4ec1cf761004160931r47cf4949o9a2fc14529c17ab1@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>
<10082.1271432484@sss.pgh.pa.us>
<h2p4ec1cf761004160931r47cf4949o9a2fc14529c17ab1@mail.gmail.com>
Josh Kupershmidt <schmiddy@gmail.com> writes:
> On Fri, Apr 16, 2010 at 11:41 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.
> Hrm, well autovacuum is at least trying to do work: it's currently
> stuck on those bloated pg_catalog tables, of course. Another developer
> killed an autovacuum of pg_attribute (or maybe it was pg_attrdef)
> after it had been running for two weeks. See current pg_stat_activity
> output attached, which shows the three autovacuum workers running plus
> two manual VACUUM ANALYZEs I started yesterday.
Two weeks? What have you got the autovacuum cost delays set to?
Once you're up to three AV workers, no new ones can get launched until
one of those finishes or is killed. So that would explain failure to
prune the stats collector's tables (the tabpurge code is only run during
AV worker launch). So what we need to figure out is why it's taking so
obscenely long to vacuum these tables ...
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: <11152.1271436528@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