upvote
Or you can do like GP with that possum and not fsync at all. It even sets synchronous=OFF, which will corrupt SQLite databases. Then it is fast because it only writes to memory. YOLO!
reply
The usual answer here is a WAL + batching multiple transactions.
reply