upvote
Turning off synchronous_commit gets you most of the way without ever worrying about data corruption if something crashes mid way through.

https://www.postgresql.org/docs/current/wal-async-commit.htm...

reply
Agreed, benchmarking, I only see a slight speedup on MacOS - https://github.com/leontrolski/postgresql-testing#:~:text=ra...
reply