Hi Josh,
it's "known" issue, see this thread:
http://archives.postgresql.org/pgsql-hackers/2010-02/thrd6.php#01290
HTH,
Kuba
Dne 8.2.2011 2:39, Josh Berkus napsal(a):
Ooops.
It looks like you are right, see ./src/backend/postmaster/pgstat.c
3c2313f4 (Tom Lane 2008-11-03 01:17:08
> Ooops.
> It looks like you are right, see ./src/backend/postmaster/pgstat.c
>
> 3c2313f4 (Tom Lane 2008-11-03 01:17:08 + 2926)
> if (last_statwrite < last_statrequest)
> 70d75697 (Magnus Hagander2008-08-05 12:09:30 + 2927)
> pgstat_write_statsfile(false);
This i
2011/2/8 Joshua D. Drake :
> On Mon, 2011-02-07 at 14:58 -0800, Josh Berkus wrote:
>> >> Anyone seen anything like this before?
>> >>
>> >
>> > it is the expected behavior, IIRC
>>
>> OK. It just seems kind of pathological for stats file writing to be 10X
>> the volume of data writing. I see why
On Mon, 2011-02-07 at 14:58 -0800, Josh Berkus wrote:
> >> Anyone seen anything like this before?
> >>
> >
> > it is the expected behavior, IIRC
>
> OK. It just seems kind of pathological for stats file writing to be 10X
> the volume of data writing. I see why it's happening, but I think it's
>
>> Anyone seen anything like this before?
>>
>
> it is the expected behavior, IIRC
OK. It just seems kind of pathological for stats file writing to be 10X
the volume of data writing. I see why it's happening, but I think it's
something we should fix.
--
-- J
2011/2/4 Josh Berkus :
> All,
>
> Seeing an issue which is new on me. On a mostly idle PostgreSQL server,
> the stats collector is rewriting the entire stats file twice per second.
>
> Version: 8.4.4
> Server: Ubuntu, kernel 2.6.32
> Server set up: ApacheMQ server. 25 databases, each of which hol
All,
Seeing an issue which is new on me. On a mostly idle PostgreSQL server,
the stats collector is rewriting the entire stats file twice per second.
Version: 8.4.4
Server: Ubuntu, kernel 2.6.32
Server set up: ApacheMQ server. 25 databases, each of which hold 2-3
tables.
Filesystem: Ext4, defau
