Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > > Now doing fsync() or fdatasync() of possibly dozens of files in a row, > > forcing the kernel to do one scattered file after another, letting the > > disk heads dance like step-chicken on a hot tin ... that will be an > > improvement, oh boy. > > I'm not convinced it would be so bad. Normally you'd only be issuing > those operations at checkpoint time, and if the bgwriter has been doing
Agreed, I don't have a problem with fsync() during checkpoint instead of sync. I had problems with fsync from the background writer and performance. Let me post ideas to hackers & win32 list. -- 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 7: don't forget to increase your free space map settings
