News for hackers. Stuff that matters.

A comment on There are only four billion floats, so test them all (2014). Parent comment

Re:There are only four billion floats, so test them all (2014) by greggyb on Monday October 12, 2020 @12:58PM (#24756535)
Disk 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.

[ Parent | on HN ]
Re:There are only four billion floats, so test them all (2014) by kortilla on Tuesday October 13, 2020 @07:12PM (#24771389)
Sub-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.

[ Parent | on HN ]