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