3 ms·
They're using WAL and synchronous = NORMAL, so there shouldn't be that many syncs to begin with. By default, I think it'd sync only on checkpoints, and a check
by cldellow 4y ago
They're using WAL and synchronous = NORMAL, so there shouldn't be that many syncs to begin with.
By default, I think it'd sync only on checkpoints, and a checkpoint would happen for every 1000 pages of WAL. 1000 is the default value of the wal_autocheckpoint pragma.
I am very surprised that you cannot reproduce more than 500 inserts/second on an NVMe drive with the same settings. I didn't try running this benchmark, as I'm not familiar with rust, but I've achieved ~15k/sec write transactions with python bindings under similar settings.