How Postgres ended up using fsync incorrectly for 20 years:
@fribbledom i'm getting the impression that either linux's implementation of fsync, or posix's definition of it, is hopelessly broken... is this not the PCLSR problem (qv. "worse is better") all over again?
@fribbledom Wow. Before the www wore me down into using e.g. mysql/mariadb I was a postgresql religious nut and very absorbed with how well ACID was implemented and so on.
I can see how the problem was masked by blaming NFS et al.
I've long used DRBD and RAID so I never realized that postgresql might be the actual problem.
Does oracle use direct i/o? I don't know.
@clacke No, you are right. I was more musing about my previous 'religious' notions about ACID.
Follow friends and discover new ones. Publish anything you want: links, pictures, text, video. This server is run by the main developers of the Mastodon project. Everyone is welcome as long as you follow our code of conduct!