4 ms·
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
by tomasol 10mo ago
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 10mo agoVery good point I've added an epilogue to the post with updated numbers Really shows the power of dynamic batching.
- cryptonector 10mo agoThank you for doing this update!