Alvaro Herrera writes:
> Excerpts from Justin Pasher's message of jue may 20 16:10:53 -0400 2010:
>> Whenever I clear out the stats for all of the databases, the file
>> shrinks down to <1MB. However, it only takes about a day for it to get
>> back up to ~18MB and then the stats collector proces
Excerpts from Justin Pasher's message of jue may 20 16:10:53 -0400 2010:
> Whenever I clear out the stats for all of the databases, the file
> shrinks down to <1MB. However, it only takes about a day for it to get
> back up to ~18MB and then the stats collector process start the heavy
> disk wr
- Original Message -
From: Justin Pasher
Date: Fri, 23 Apr 2010 17:46:16 -0500
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Alvaro Herrera
CC: pgsql-general@postgresql.org
- Original Message -
From: Alvaro Herrera
Date: Fri, 23 Apr 2010 18:28:03
- Original Message -
From: Alvaro Herrera
Date: Fri, 23 Apr 2010 18:28:03 -0400
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher
CC: dep...@depesz.com, pgsql-general@postgresql.org
Justin Pasher wrote:
Agh... I used pg_stats_reset (with an s
Justin Pasher writes:
> Agh... I used pg_stats_reset (with an s) when searching for it. I ran
> the function and it returned true, but the stats file only shrunk by
> ~100k (still over 18MB total). Is there something else I need to do?
pg_stat_reset only resets the data for the current databas
Justin Pasher wrote:
> Agh... I used pg_stats_reset (with an s) when searching for it. I
> ran the function and it returned true, but the stats file only
> shrunk by ~100k (still over 18MB total). Is there something else I
> need to do? Does this mean the file is mostly bloated with bogus
> data t
> I'm guessing I should just try to delete the file outright?
>
Err... I meant "should NOT" delete.
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
- Original Message -
From: hubert depesz lubaczewski
Date: Fri, 23 Apr 2010 23:40:35 +0200
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher
CC: pgsql-general@postgresql.org
On Fri, Apr 23, 2010 at 03:27:55PM -0500, Justin Pasher wrote:
haven
On Fri, Apr 23, 2010 at 03:27:55PM -0500, Justin Pasher wrote:
> haven't tweaked any settings from the defaults. My
> $PGDATA/global/pgstat.stat file is about 18MB, if that helps. Does
> it really rewrite this entire file every 500ms? Alvaro suggested
> resetting the stats, but I'm having trouble f
Hello,
Redhat EL4 update 8, 2.6.9-89.0.23.ELsmp
Quad Proc, Dual Core Xeon, 16GB RAM
Postgres 8.1.18
I'm having some trouble pinning down exactly what is causing our
Postgres cluster to run slowly. After some initial investigation, I
noticed that the disk write activity is consistently high, an
10 matches
Mail list logo