Re:Are You Sure You Want to Use MMAP in Your Database Manage...
by AdamProut on Sunday July 02, 2023 @11:51PM
(#36568550)
Yeah for workloads with any long running write transactions a single writer design is a pretty big limitation. Say some long running data load (or a big bulk deletion) running along with some faster high throughput key value writes - the big data load would block all the faster key-value writes when it runs.
No "mainstream" database I'm aware of has a global single writer design.
No "mainstream" database I'm aware of has a global single writer design.