On Wed, Mar 16, 2005 at 11:20:12PM -0500, Bruce Momjian wrote: > > Basically we do open_datasync -> fdatasync -> fsync. This is > empirically what we found to be fastest on most operating systems, and > we default to the first one that exists on the operating system. > > Notice we never default to open_sync. However, on Win32, Magnus got a > 60% speedup by using open_sync, implemented using > FILE_FLAG_WRITE_THROUGH. Now, because this the fastest on Win32, I > think we should default to open_sync on Win32. The attached patch > implements this. > > 2. Another question is what to do with 8.0.X? Do we backpatch this for > Win32 performance? Can we test it enough to know it will work well? > 8.0.2 is going to have a more rigorous testing cycle because of the > buffer manager changes. > My preference would be to back-patch to 8.0.1. I have some projects where the performance difference will decide whether or not they go with MSSQL or PostgreSQL.
Ken ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match