News for hackers. Stuff that matters.
Re:SQLite – The “server-process-edition” branch by singron on Thursday August 16, 2018 @12:52AM (#17771975)
Without fsync, the dirty page can sit in RAM and not even be sent to the disk, so a battery backup for the disk wouldn't solve data loss.
Re:SQLite – The “server-process-edition” branch by latch on Thursday August 16, 2018 @03:12AM (#17772570)
Right..but you leave fsync on in this case, no? This might be incompatible with the locking required by this server-process edition though (I guess, no clue). But more generally speaking, fsync=on with a proper raid controller gives massive performance boost (like orders of magnitude) while being relatively resilient to power loss.