From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Megabytes of stats saved after every connection |
Date: | 2005-07-29 01:08:33 |
Message-ID: | 20050729010833.GL6807@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 28, 2005 at 05:48:21PM -0500, Guy Rouillier wrote:
> 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?
The stats file is dispensable. In fact, it has been proposed that on
crash recovery the stat file should be deleted.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-07-29 01:12:59 | Re: Select for update |
Previous Message | Phil Endecott | 2005-07-28 22:49:03 | Re: Megabytes of stats saved after every connection |