Re: Megabytes of stats saved after every connection

From: "Guy Rouillier" <guyr(at)masergy(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Megabytes of stats saved after every connection
Date: 2005-07-28 22:48:21
Message-ID: CC1CF380F4D70844B01D45982E671B239E89E3@mtxexch01.add0.masergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2005-07-28 22:49:03 Re: Megabytes of stats saved after every connection
Previous Message Havasvölgyi Ottó 2005-07-28 22:05:46 Re: Select for update