Why Your SSD (Probably) Sucks and What Your Database Can Do About It
Why Your SSD (Probably) Sucks and What Your Database Can Do About It Database system developers have a complicated relationship with storage devices: They can store terabytes of data cheaply, and everything is still there after a system crash. On the other hand, storage can be a spoilsport by being....
Hasnain says:
“In this case, however, you probably have other, more catastrophic data loss vectors to worry about. In other words: You probably don’t care if the fsync call completed when your laptop burns down in a house fire or gets stolen - the data is gone anyway.
If you are running database systems in a production environment, you (or your cloud provider) are hopefully using enterprise-grade SSDs with capacitor-backed write cache that have great write latency.”
Posted on 2024-07-01T01:57:46+0000