PostgreSQL 8.2 를 설치한 김에 pgbench 를 한번 돌려 봤습니다.
2대의 동일 하드웨어 사양인 서버에 x86 Linux 와 x86_64 Linux 를 설치하여 수행 하였습니다.
하드웨어 스펙은 다음과 같습니다.
Model : IBM 306m
CPU : Intel(R) Pentium(R) 4 CPU 3.20GHz
Memory : 1024MB
Storage : SATA 80GB
OS : CentOS 4.4 Kernel 2.6.9-42.0.3.ELsmp
CentOS x86 |
[postgres@x86-jaker ~]$ /usr/local/pgsql/bin/pgbench -n -c 100 -t 100 -S
transaction type: SELECT only
scaling factor: 1
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 5543.267978 (including connections establishing)
tps = 6218.290604 (excluding connections establishing)
[postgres@x86-jaker ~]$ /usr/local/pgsql/bin/pgbench -n -c 100 -t 100
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 243.158221 (including connections establishing)
tps = 244.326912 (excluding connections establishing)
|
CentOS x86_64 |
[postgres@x86-64-jaker ~]$ /usr/local/pgsql/bin/pgbench -n -c 100 -t 100 -S
transaction type: SELECT only
scaling factor: 1
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 4919.705487 (including connections establishing)
tps = 5591.058779 (excluding connections establishing)
[postgres@x86-64-jaker ~]$ /usr/local/pgsql/bin/pgbench -n -c 100 -t 100
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 100
number of transactions per client: 100
number of transactions actually processed: 10000/10000
tps = 138.554470 (including connections establishing)
tps = 139.023920 (excluding connections establishing) |
흠...이 결과를 어떻게 받아 들여야 할지.....
일단 DB Server 로는 저사양이긴 합니다만 비슷한 환경에서 사용하고 계실분도 있으실거라 생각되어 결과를 올려 봅니다.
상위 스펙의 서버에서 테스트 할 기회가 생기면 결과를 올리도록 하겠습니다.
|