Re: stats collector suddenly causing lots of IO - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: stats collector suddenly causing lots of IO
Date
Msg-id 20100413215522.GI2990@alvh.no-ip.org
Whole thread Raw
In response to stats collector suddenly causing lots of IO  (Chris)
List pgsql-performance
Chris wrote:
> I have a lot of centos servers which are running postgres.  Postgres isn't used
> that heavily on any of them, but lately, the stats collector process keeps
> causing tons of IO load.  It seems to happen only on servers with centos 5.

Does this correlate to an increase in size of the pgstat.stat file?
Maybe you could try resetting stats, so that the file goes back to an
initial size and is slowly repopulated.  I'd suggest monitoring the size
of the stats file, just in case there's something abnormal with it.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: "could not open relation..."
Next
From: Krzysztof Kardas
Date:
Subject: Re: PostgreSQL with Zabbix - problem of newbe