Re: Changing the default wal_sync_method to open_sync for

On Wed, 16 Mar 2005, Bruce Momjian wrote:

> Magnus Hagander wrote:
>> I'd like to see this one also considered for 8.0.x, though I'd certainly
>> like to see some more testing as well. Perhaps it's suitable for the
>> "8.0.x with extended testing" that is planned for the ARC replacement
>> code?
>>
>> It does make a huge difference on win32. While we definitly don't want
>> to risk data, a 60% speedup in write intensive apps is a *lot*.
>
> 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.

Considering how stable an Operating System Windows *isn't*, I think the
first thing Magnus states very much goes against making this the default:
"While we definitely don't want to risk data..." ...

Setting something like this that increases the risk to data should never
be 'the default behaviour', but a conscious decision on the part of the
administrator of the individual system ... and even then, with a good
skull-n-cross bones warning around it so that they understand the risks
...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664