From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: David Barton <dave@oneit.com.au>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
Date: Tue, 31 Jul 2012 13:21:04 +1200
Message-ID: <50173300.20800@catalyst.net.nz> (raw)
In-Reply-To: <50141C7A.4050607@oneit.com.au>
References: <50136B8D.7070502@oneit.com.au>
<29996.1343492034@sss.pgh.pa.us>
<50141C7A.4050607@oneit.com.au>
On 29/07/12 05:08, David Barton wrote:
> Thanks so much, Tom.
>
> That did the job. I increased it to every 15 minutes and it has
> dropped substantially even though the pgstat.stat file is over 1 MB
> again.
>
>
I'd be a little concerned that having autovacuum tuned down to run so
infrequently might result in massive table bloat - which could be even
worse than than the original stats file problem. Keep an eye out for
any table(s) that used to be small but become unexpectedly larger over
the next few days, and if you see any then decrease the naptime again.
Regards
Mark
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: mark.kirkwood@catalyst.net.nz, dave@oneit.com.au, tgl@sss.pgh.pa.us
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
In-Reply-To: <50173300.20800@catalyst.net.nz>
* 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