There are only four billion floats, so test them all (2014)

Re:There are only four billion floats, so test them all (2014) by kortilla on Sunday October 11, 2020 @02:25PM (#24747895)

The trade-off isn’t really size in a lot of cases though. When stuff is stored in RAM you lose the persistence story.

[ Parent | on HN ]

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 ]