Re: [HACKERS] FYI: fdatasync vs sync_file_range

2009-07-06 Thread Heikki Linnakangas
Fujii Masao wrote: > According to the result, using sync_file_range instead of fdatasync > has little effect in the performance of postgres. When we flush the WAL, we flush everything we've written that far. I'm not surprised that sync_file_range makes no difference; it does the same amount of I/O

Re: [HACKERS] FYI: fdatasync vs sync_file_range

2009-07-06 Thread Simon Riggs
On Mon, 2009-07-06 at 17:54 +0900, Fujii Masao wrote: > According to the result, using sync_file_range instead of fdatasync > has little effect in the performance of postgres. ["...when flushing XLOG"] Why did you think it would? AFAICS the range of dirty pages will be restricted to a fairly t