[postgresql]d945gclfのpgbenchやり直し(2008/07/20)

　d945gclfのものを取り直したわけではないが、前回scaling factorが間違っていたのでやり直しを含めて再度投稿。

d945gclf:postgresql8.3

メモリ:2GB 533MHzで動作
CPU:Atom230
HDD:250G 7200rpm Hitachi（STATA II）

-bash-3.2$ ./pgbench -c 50 -t 100 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 60
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 170.997866 (including connections establishing)
tps = 172.326453 (excluding connections establishing)

Dell PowerEdge sc440:postgresql8.3

CPU:Intel(R) Pentium(R) Dual  CPU  E2180  @ 2.00GHz
メモリ:3,114,508 kB（つまり3Gぐらい）
HDD:SATAII(7,200回転だったかな？)

$ pgbench -c 50 -t 100 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 60
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 227.489773 (including connections establishing)
tps = 228.651036 (excluding connections establishing)

Dell PowerEdge sc440:postgresql8.1

$ pgbench -c 50 -t 100 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 60
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 165.544441 (including connections establishing)
tps = 166.139285 (excluding connections establishing)
※他のサービスtomcat等も動いているのであくまで参考データとして。