[EMAIL PROTECTED] 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster