pgbench

Started by Peter Kellerover 24 years ago1 messagesgeneral
Jump to latest
#1Peter Keller
peter.keller@bvv.bayern.de

Hi all,
my company is going to buy new server. It will mainly be used as a database
server (of cause PostgreSQL).
Today I tested 2 server which are almost identical:

1.4 Athlon CPU
2 GB DDR with ECC
harddisk is an IBM Ultrastar 36LP (SCSI)
and raid system

The operating system is Linux with a 2.4.10 kernel.
The version of PostgreSQL is 7.1

From server 1 I got this results from pgbench: about 90 tps

but from the server 2 I got this: 9 tps !!!!!
(pgbench with various settings and scaling factors)

Has anybody an idea why the results differ so much?

Thanks Peter

--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
...............................................................................................
Peter Keller : Tel: (+49) 089-2190-2594
Vermessungsrat : Fax: (+49) 089-2190-2459
Alexandrastr. 3 : mailto:Peter.Keller@bvv.bayern.de
80538 Muenchen : web: http://www.bayern.de/vermessung