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
