Re: Simplifying wal_sync_method - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simplifying wal_sync_method
Date
Msg-id 10591.1123545884@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simplifying wal_sync_method  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Simplifying wal_sync_method  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Simplifying wal_sync_method  (Marko Kreen <marko@l-t.ee>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simplifying wal_sync_method
Next
From: Kris Jurka
Date:
Subject: Re: Simplifying wal_sync_method