Re: fsync vs open_sync

pgsql@mohawksoft.com wrote:
> Furthermore, it seems to also have the added benefit of reducing the I/O
> storm at checkpoints over a system running with fsync off.
> 
> I'm really serious about this, changing this one parameter had dramatic
> results on performance. We should have a general call to users to test
> this setting with their OS of choice. If not that, if we can be sure that
> there are no cases where using O_SYNC is worse than fsync() or
> fdatasync(), it should be considered as the default.

Agreed.  Have you looked at src/tools/fsync?

--  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,
Pennsylvania19073