A fun article about PostgreSQL and fsync():

"PostgreSQL's fsync() surprise"

https://lwn.net/Articles/752063/