Re: fsync or fdatasync - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: fsync or fdatasync
Date
Msg-id 200209101717.g8AHHuV29296@candle.pha.pa.us
Whole thread Raw
In response to Re: fsync or fdatasync  (Ragnar Kjørstad <postgres@ragnark.vestdata.no>)
Responses Re: fsync or fdatasync
List pgsql-admin
Ragnar Kj�rstad wrote:
> On Tue, Sep 10, 2002 at 11:40:24AM -0400, Bruce Momjian wrote:
> >
> > The original poster was wrong about the default.
> >
> > We use fdatasync where available, and fsync when it is not.
>
> Makes sense.
>
> > We also use
> > O_SYNC on open if it is available.
>
> Why? That will slow tings down...

Actually, no, we are only O_SYNC'ing the WAL writes and sometimes that
is faster because you are not writing then fsyncing, you are just
writing.  The fdatasync only is better than O_SYNC when you are doing
multiple WAL writes before an fdatasync and we normally don't do that.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: Jodi Kanter
Date:
Subject: Fw: consulta
Next
From: Ragnar Kjørstad
Date:
Subject: Re: fsync or fdatasync