"Merlin Moncure" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Does it help if you change FlushBuffer to release buffer lock while >> flushing xlog?
> Putting your change in resulted in about a 15% increase in insert > performance. There may be some quirky things going on here with NTFS... > I did an update clean from cvs and I noticed big speedup across the > board. Right now sync performance is right in line with my > expectations. In any case, I checked and confirm that there are no > spurious fsyncs running when they are not supposed to be. Was that 15% before or after updating from CVS? The more I think about the looping aspect the less I like it, so I'd prefer not to pursue making the unlock change for real. But if it's really a 15% win then maybe we need to... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])