4 ms·
But, for insert, the CPU is not the bottleneck. It's I/O constrained. Disk I/O has always been the bottleneck for writes.
by ijidak 4y ago
But, for insert, the CPU is not the bottleneck. It's I/O constrained.
Disk I/O has always been the bottleneck for writes.
- jandrewrogers 4y agoCounterintuitively, write performance in modern databases is primarily constrained by disk read performance. That said, it is increasingly rare for disk I/O to be a bottleneck for inserts. When your storage will happily sustain 10+ GB/s of write throughput, you tend to run out of things like network and memory bandwidth first.
- Proven 4y ago[dead]