Y
Hacker News
new
|
ask
|
show
|
jobs
by
ltbarcly3
7 hours ago
Just turning off fsync is basically just as fast as a ramdisk and you can't use up all your memory with one big test.
2 comments
koolba
7 hours ago
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...
link
leontrolski
5 hours ago
Agreed, benchmarking, I only see a slight speedup on MacOS -
https://github.com/leontrolski/postgresql-testing#:~:text=ra...
link
https://www.postgresql.org/docs/current/wal-async-commit.htm...