Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+ - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+
Date
Msg-id 4CFB0339.7040009@agliodbs.com
Whole thread Raw
In response to Re: [PATCH] Revert default wal_sync_method to fdatasync on Linux 2.6.33+  (Josh Berkus <josh@agliodbs.com>)
List 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
 


pgsql-hackers by date:

Previous
From: Vaibhav Kaushal
Date:
Subject: Re: Requirement for the Buffer manager to load multiple pages at once
Next
From: Itagaki Takahiro
Date:
Subject: Re: SQL/MED - file_fdw