9.6 and fsync=off - Mailing list pgsql-hackers

From Craig Ringer
Subject 9.6 and fsync=off
Date
Msg-id CAMsr+YGechDvrFj4xwoBWhJ7rW25Avqo+UqcyqbnS=LTFdGJ4g@mail.gmail.com
Whole thread Raw
Responses Re: 9.6 and fsync=off
Re: 9.6 and fsync=off
List pgsql-hackers
Hi all

After helping clean up the mess from another user who turned fsync=off because they read (bad) tuning advice that it was faster, I'd really like to change the config file comment.

Really.

#fsync = on                             # turns forced synchronization on or off

Now, we can't rename fsync to disable_crash_safety=on or corrupt_my_database=on. But the comment needs changing.

How about:

#fsync = on                             # force disk flushes required for crash safety

or, preferably something like:

"Enable forced disk flushes when they are required for crash safety. Disabling fsync can lead to unrecoverable database corruption in a crash of the host system."

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Christian Ullrich
Date:
Subject: Re: Parallel build with MSVC
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: 9.6 and fsync=off