upvote
The usual answer here is a WAL + batching multiple transactions.
reply