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

From Tom Lane
Subject Re: no universally correct setting for fsync
Date
Msg-id 12203.1273242287@sss.pgh.pa.us
Whole thread Raw
In response to no universally correct setting for fsync  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> | If you trust your operating system, your hardware, and your
> | utility company (or your battery backup), you can consider
> | disabling fsync.
> Isn't this a little too rosy a picture to paint?

I think that statement is true as far as it goes, but I agree with
rejiggering the surrounding text.  The whole thing was written back
when Postgres was by far the least reliable component of the stack.
It isn't anymore.  We should make it clear that fsync=off is not ever
recommended for production.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: no universally correct setting for fsync
Next
From: Robert Haas
Date:
Subject: beta to release