Re: fsync method checking - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: fsync method checking
Date
Msg-id 4059E912.2050509@dunslane.net
Whole thread Raw
In response to Re: fsync method checking  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: fsync method checking  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers

Bruce Momjian wrote:

>I have been poking around with our fsync default options to see if I can
>improve them.  One issue is that we never default to O_SYNC, but default
>to O_DSYNC if it exists, which seems strange.
>
>What I did was to beef up my test program and get it into CVS for folks
>to run.  What I found was that different operating systems have
>different optimal defaults.  On BSD/OS and FreeBSD, fdatasync/fsync was
>better, but on Linux, O_DSYNC/O_SYNC was faster.
>
>[snip]
>
>Linux 2.4.9:
>    
>

This is a pretty old kernel (I am writing from a machine running 2.4.22)

Maybe before we do this for Linux testing on a more modern kernel might 
be wise.

cheers

andrew



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Further thoughts about warning for costly FK checks
Next
From: Richard Huxton
Date:
Subject: Re: Further thoughts about warning for costly FK checks