[pgcluster: 456] pgbenchのパフォーマンス

[Tomokazu Kuribayashi]

栗林です。

現在、reliableモードの検証を行っています。

パフォーマンスが思ったよりも出ないのと、クライアント数を増やすと、
極端にレスポンスが遅くなります。
デバッグログはまだ詳しくみていません。

以下のログがpgbenchの計測結果ですが、この内容が妥当なのか判断つか
ない状況です。２回のみ書き出してますが、だいたい同じような値です。
pgbenchで計測された方がいましたら、参考に計測結果を教えていただけ
ませんでしょうか？


# ResponseMode = Normal
pgbench -c 10 -t 5 pgbench
------------------------------------------------------------
tps = 15.456271 (including connections establishing)
tps = 17.653435 (excluding connections establishing)
------------------------------------------------------------
tps = 12.503157 (including connections establishing)
tps = 13.912598 (excluding connections establishing)
------------------------------------------------------------

# ResponseMode = Normal
pgbench -c 20 -t 5 pgbench
------------------------------------------------------------
tps = 2.605245 (including connections establishing)
tps = 2.660830 (excluding connections establishing)
------------------------------------------------------------
tps = 2.714726 (including connections establishing)
tps = 2.775284 (excluding connections establishing)


# ResponseMode = Reliable
pgbench -c 10 -t 5 pgbench
------------------------------------------------------------
tps = 10.745675 (including connections establishing)
tps = 11.757145 (excluding connections establishing)
------------------------------------------------------------
tps = 11.618213 (including connections establishing)
tps = 12.811138 (excluding connections establishing)

# ResponseMode = Reliable
pgbench -c 20 -t 5 pgbench
------------------------------------------------------------
tps = 1.010096 (including connections establishing)
tps = 1.018313 (excluding connections establishing)
------------------------------------------------------------
tps = 1.477009 (including connections establishing)
tps = 1.494616 (excluding connections establishing)


# 参考にselectの場合です。
pgbench -S -c 20 -t 5 pgbench
tps = 99.485758 (including connections establishing)
tps = 498.967138 (excluding connections establishing)
------------------------------------------------------------
tps = 99.957118 (including connections establishing)
tps = 491.629999 (excluding connections establishing)



postgresql.confの変更点
max_connections = 1024
shared_buffers = 8192
wal_sync_method = open_sync

動作環境、構成
OS:RedHat9
CPU:Xeon CPU 3.06GHz * 2
MEM:1GB
HDD:SCSI Raid-0
PgCluster:1.0.7av11
Replicate*2 - Cluster*3 - Loadbalancer


以上、宜しくお願い致します。

//-----------------------------------------//
// Tomokazu Kuribayashi                    //
// Mail : k-tomo99 ＠ zap.att.ne.jp           //
//-----------------------------------------//