Re: Simplifying wal_sync_method

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Marko Kreen <marko@l-t.ee>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2005-08-09T00:04:44Z
Lists: pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Marko Kreen wrote:
>> On same topic:
>> http://archives.postgresql.org/pgsql-general/2005-07/msg00811.php
>> Why does win32 PostgreSQL allow data corruption by default?

> It behaves the same on Unix as Win32, and if you have battery-backed
> cache, you don't need writethrough, so we don't have it as default.  I
> am going to write a section in the manual for 8.1 about these
> reliability issues.

I thought we had changed the default for Windows to be fsync_writethrough
in 8.1?  We didn't have that code in 8.0, but now that we do, it surely
seems like the sanest default.

			regards, tom lane