3 ms·
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.
by ltbarcly3 2mo 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.
- koolba 2mo agoTurning 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.html https://www.postgresql.org/docs/current/wal-async-commit.htm...
- leontrolski 2mo agoAgreed, benchmarking, I only see a slight speedup on MacOS - https://github.com/leontrolski/postgresql-testing#:~:text=ramdisk https://github.com/leontrolski/postgresql-testing#:~:text=ra...