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

Re: Large pgstat.stat file causes I/O storm

From: Cristian Gafton <gafton(at)rpath(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Large pgstat.stat file causes I/O storm
Date: 2008-01-29 16:43:46
Message-ID: Pine.LNX.4.64.0801291143070.19796@alienpad.rpath.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 29 Jan 2008, Cristian Gafton wrote:

> I have a ~150GB sized server, containing two databases that are active in 
> mostly read mode. I have noticed lately that the global/pgstat.stat file is 
> somewhere around 1MB freshly after a restart, but at some point it baloons to 
> 74MB in size for no apparent reason, after a few hours of uptime. Needless to 
> say, having the stats collector dump 74MB of stuff on disk on its every loop 
> takes a big bite of the I/O capabilities of this box.

Of course, leaving out the most important thing - this is postgresql 8.2.6 
on x86_64

> Looking at all the othe replicas I have of this database (but which are under 
> a more lightweight read load), the pgstat.stat file again is rather small in 
> size. Am I right to assume that a 74MB pgstat.stat file is not normal - and 
> what might have caused it?

Cristian
-- 
Cristian Gafton
rPath, Inc.


In response to

Responses

pgsql-hackers by date

Next:From: Jeff DavisDate: 2008-01-29 17:48:15
Subject: Re: [PATCHES] Proposed patch: synchronized_scanningGUCvariable
Previous:From: Cristian GaftonDate: 2008-01-29 16:39:02
Subject: Large pgstat.stat file causes I/O storm

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