Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+

All,

While I have this machine available I've been trying to run some 
performance tests using pgbench and various wal_sync_methods.  However, 
I seem to be maxing out at the speed of pgbench itself; no matter which 
wal_sync_method I use (including "fsync"), it tops out at around 2750 TPS.

Of course, it's also possible that the wal_sync_method does not in fact 
make a difference in throughput.

--                                   -- Josh Berkus                                     PostgreSQL Experts Inc.
                           http://www.pgexperts.com