fsync() errors is unsafe and risks data loss at least on XFS

[Predrag Punosevac]

Dear Autonians,

I am not sure how many of you read PostgreSQL mailing lists but this is
one of the most interesting exchanges I came across in a long while.

https://www.postgresql.org/message-id/flat/CAEepm%3D0B9f0O7jLE3ipUTqC3V6NO2LNbwE9Hp%3D3BxGbZPqEyQg%40mail.gmail.com#CAEepm=0B9f0O7jLE3ipUTqC3V6NO2LNbwE9Hp=3BxGbZPqEyQg@mail.gmail.com

Long story short if you have any serious amount of data in a PostgreSQL
database you should be using ZFS found on IllumOS kernel (Open Solaris
derivative) or FreeBSD. As you know we in the Auton Lab run ZFS of
FreeBSD.

Best,
Predrag