Whats the obsession with concurrent writes?

Single writer will outperform MVCC as long as you do dynamic batching (doesn't prevent logical transactions) and all you have to do is manage that writer at the application level.

Concurrent writers just thrash your CPU cache. The difference between L1 and L3 can be 100x. So your single writer on a single core can outperform 10-100s of cores. Especially when you start considering contention.

Here's sqlite doing 100k TPS and I'm not even messing with core affinity and it's going over FFi in a dynamic language.

https://andersmurphy.com/2025/12/02/100000-tps-over-a-billio...