Comment by tomasol

Comment by tomasol 14 hours ago

1 reply

fsync is the most expensive operation during a write. NORMAL mode means you don't care whether last ~100 ms of transactions before a process crash / VM restart are going to be persisted or not. My suggestion is either to use synchronous="full" or disable `synchronous_commit` on Postgres to avoid comparing apples to oranges.

Edit: Also, the example indicates financial transactions. Can you explain why you need serializability but not durability?

andersmurphy 5 hours ago

Very good point I've added an epilogue to the post with updated numbers

Really shows the power of dynamic batching.