Re: no universally correct setting for fsync - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: no universally correct setting for fsync
Date
Msg-id 4BE7E62C02000025000314B7@gw.wicourts.gov
Whole thread Raw
In response to Re: no universally correct setting for fsync  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: no universally correct setting for fsync
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> "It might be safe" is a bit of a waffle.  It would be nice if we
> could provide some more clear guidance as to whether it is or is
> not, or how someone could go about testing their hardware to find
> out.
I think that the issue is that you could have corruption if some,
but not all, disk sectors from a page were written from OS cache to
controller cache when a failure occurred.  The window would be small
for a RAM-to-RAM write, but it wouldn't be entirely *safe* unless
there's some OS/driver environment where you could count on all the
sectors making it or none of them making it for every single page. 
Does such an environment exist?
-Kevin


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: no universally correct setting for fsync
Next
From: Stephen Frost
Date:
Subject: Re: max_standby_delay considered harmful