Hi, I tested dbt-2 benchmark in single instance and synchronous replication. Unfortunately, my benchmark results were not seen many differences...
* Test server
Server: HP Proliant DL360 G7
CPU: Xeon E5640 2.66GHz (1P/4C)
Memory: 18GB(PC3-10600R-9)
Disk: 146GB(15k)*4 RAID1+0
RAID controller: P410i/256MB
* Result
** Single instance**
| NOTPM | 90%tile | Average | S.Deviation
------------+-----------+-------------+---------+-------------
no-patched | 3322.93 | 20.469071 | 5.882 | 10.478
patched | 3315.42 | 19.086105 | 5.669 | 9.108
** Synchronous Replication **
| NOTPM | 90%tile | Average | S.Deviation
------------+-----------+-------------+---------+-------------
no-patched | 3275.55 | 21.332866 | 6.072 | 9.882
patched | 3318.82 | 18.141807 | 5.757 | 9.829
** Detail of result
http://pgstatsinfo.projects.pgfoundry.org/DBT-2_Fujii_patch/
I set full_page_write = compress with Fujii's patch in DBT-2. But it does not
seems to effect for eleminating WAL files. I will try to DBT-2 benchmark more
once, and try to normal pgbench in my test server.
Regards, -- Mitsumasa KONDO NTT Open Source Software Center
<<attachment: single-throughput.png>>
<<attachment: synchronous-throughput.png>>
<<attachment: single-latency.png>>
<<attachment: synchronous-latency.png>>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
