You don’t need fsync at all for that, just WAL. fsync is only half arsed on Apple platforms.

You need write barriers for the ordering guarantees of a WAL. that’s why Apple uses barrier sync and not full sync. AFAIK other operating systems do not have this distinction.