> The real question is how much of a speed-up fsync provides compared to
> the same workload with synchronous_commit disabled. The only case for
> fsync=off is one where that number is much faster.
I can't say I've tested this. Most of my head-to-heads on fsync were
before asych existed.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com