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