News for hackers. Stuff that matters.
Re:PostgreSQL's fsync surprise by quickben on Thursday May 03, 2018 @12:22AM (#16983335)
> "ideally I want:

- Write() to be blocking / atomic by default. Don't return until data is safely committed."

How do you deal with user pulling out usb stick?

Re:PostgreSQL's fsync surprise by josephg on Thursday May 03, 2018 @12:41AM (#16983395)
There's a bunch of ways to solve this. A WAL or a B+ tree both handle this sort of thing correctly.
Re:PostgreSQL's fsync surprise by tinus_hn on Thursday May 03, 2018 @02:26PM (#16988431)
I would love it if the OS just said ‘put it back or your files are gone’ and then let you reinsert the drive without data loss.