On Wed, 2019-08-28 at 12:27 -0600, Michael Lewis wrote: > > You can do almost as good by setting "synchronous_commit = off", > > and that is crash-safe. > > It seems like it depends on your definition of crash-safe. Data loss > can occur but not data corruption, right?
Right. > Do you know any ballpark for how much difference in performance it > makes to turn off synchronous_commit or what type of hardware or > usage it would make the biggest (or least) difference? In my experience, the performance will be almost as good as with fsync=off, which is as good as it gets. For an exact answer for your specific system, run a simple benchmark. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com