Paul Guo <pguo(at)pivotal(dot)io> writes:
> table directories & wal fsync probably dominates the fsync time. Do we
> know any possible real scenario that requires table directory fsync?
Yes, there are filesystems where that's absolutely required. See
past discussions that led to putting in those fsyncs (we did not
always have them).
regards, tom lane