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

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Date: 2010-12-05T03:12:57Z
Lists: pgsql-hackers
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