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