A database write never becomes fast for free; the engine simply defers the work or delegates durability to another tier. When a storage engine returns an immediate acknowledgment, it is either risking data loss in volatile memory or offloading background compaction and replication costs downstream.
Calling fdatasync on a local NVMe drive provides process and host crash safety, but it cannot survive node death. Moving that guarantee across the network introduces round-trip penalties, while modern object-store architectures replace small random disk page updates with immutable log-structured merge trees.
In these disaggregated architectures, compute nodes stay stateless while the remote tier assumes full responsibility for durability. You trade write path simplicity for background compaction storms and read index overhead.
Every microsecond trimmed from your primary write path is paid back later during compaction or recovery.




