2 ms·
The trade-off isn’t really size in a lot of cases though. When stuff is stored in RAM you lose the persistence story.
by kortilla 6y ago
The trade-off isn’t really size in a lot of cases though. When stuff is stored in RAM you lose the persistence story.
- greggyb 6y agoDisk storage for the WAL and periodic checkpoints can get you sub-second recovery targets easily. Ninja edit: or a UPS and a shutdown procedure triggered by it that writes the database to disk. You can write 100GB in a couple minutes over a 10Gbps network. Faster to a local SSD.
- kortilla 6y agoSub-second recovery and UPS triggered shutdowns are still nowhere near the reliability of a database ensuring fsync has been called when you call “commit”. There are just certain classes of data (e.g. any kind of business transaction) where you can’t afford this type of best effort durability.