sonic と pro で PostgreSQL 7.2 の pgbench

Linux マシンである sonic と pro で pgbench をとってみた。10回くらいやって、一番よかった値。

- sonic で pgbench

[postgres@pro pgbench]$ pgbench postgres
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 1
number of transactions per client: 10
number of transactions actually processed: 10/10
tps = 9.607025(including connections establishing)
tps = 11.733426(excluding connections establishing)

sonic のマシンスペック

OS: TurboLinux Server 6.5
CPU: Pentium 133MHz
Memory: 64MB
HDD: 4.3GB
NIC: Intel i82557

- pro で pgbench

つづいて pro。やっぱ倍くらい違うな。

[postgres@pro pgbench]$ pgbench postgres
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 1
number of transactions per client: 10
number of transactions actually processed: 10/10
tps = 20.484373(including connections establishing)
tps = 23.593809(excluding connections establishing)

pro のマシンスペック

OS: TurboLinux Server 6.5
CPU: MMX Pentium 200MHz
Memory: 128MB
HDD: 8.4GB
NIC: 3COM 3C905B