Skip site navigation (1) Skip section navigation (2)

Re: Postgres 9.1.4 - high stats collector IO usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Barton <dave(at)oneit(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
Date: 2012-07-28 16:13:54
Message-ID: 29996.1343492034@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
David Barton <dave(at)oneit(dot)com(dot)au> writes:
> I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is 
> generating very high IO usage even when nothing appears to be happening 
> on the system.

> I have roughly 150 different databases, each of which is running in 1 of 
> roughly 30 tablespaces.  The databases are small (the dump of most is 
> are under 100M, and all but 3 are under 1G, nothing larger than 2G).

That's a lot of databases.  I think your problem probably stems from
autovacuum madly trying to cover all of them.  Backing off (increasing)
autovacuum_naptime to slow its cycle might help.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: David BartonDate: 2012-07-28 17:08:10
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
Previous:From: Pavel StehuleDate: 2012-07-28 07:07:48
Subject: Re: Postgres 9.1.4 - high stats collector IO usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group