Re: Megabytes of stats saved after every connection - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Megabytes of stats saved after every connection
Date
Msg-id CC1CF380F4D70844B01D45982E671B239E89E3@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Megabytes of stats saved after every connection  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
Responses Re: Megabytes of stats saved after every connection
List pgsql-general
Jan Wieck wrote:

> Then again, the stats file is only written. There is nothing that
> actually forces the blocks out. On a busy system, one individual stats
> file will be created, written to, renamed, live for 500ms and be
> thrown away by the next stat files rename operation. I would assume
> that with a decent filesystem and appropriate OS buffers, none of the
> data blocks of most stat files even hit the disk. I must be missing
> something.

(From someone who is at best semi-informed).. Unless battery-backed
cache is available, we are advised to run with fsync enabled.  Wouldn't
that affect the stats files as well?

--
Guy Rouillier


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Megabytes of stats saved after every connection
Next
From: "Peter L. Berghold"
Date:
Subject: ecpg and C++