temp

繋ぐ前
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 1033.979567 (including connections establishing)
tps = 1048.962859 (excluding connections establishing)

つないだあと 非同期
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 916.261320 (including connections establishing)
tps = 928.088200 (excluding connections establishing)

同期 synchronous_commit=on
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 614.869109 (including connections establishing)
tps = 620.205578 (excluding connections establishing)

同期 synchronous_commit=local
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 936.991185 (including connections establishing)
tps = 949.348462 (excluding connections establishing)

同期 synchronous_commit=remote_write
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 757.808267 (including connections establishing)
tps = 766.024251 (excluding connections establishing)

参考まで synchronous_commit=off
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -c 100 -t 100 bench00
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 100
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 1364.206602 (including connections establishing)
tps = 1390.885196 (excluding connections establishing)