On Sunday, March 22, 2015, Florian Weimer <
fw@deneb.enyo.de> wrote:
* David G. Johnston:
> "enables or disables data durability promise of ACID." ?
“fsync = on” only works if the storage stack doesn't do funny things.
Depending on the system, it might not be sufficient.
Allows for (underlying storage not withstanding) or disables, then.
But that distinction is present no matter what so from the standpoint the alternative is no worse and at least tells the user that a key promise of RDBMS is being voluntarily waived if they disable this setting.
Given the existence of developer settings I would add this to that list. People wanting specialized configurations where this would be disabled will learn about it elsewhere, confirm its existence in the docs, and then add it to their custom configuration. Those who do not learn elsewhere probably shouldn't be changing it in the first place.
David J.