pgbench

From: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: pgbench
Date: 2001-10-10 14:13:58
Message-ID: 200110101414.QAA05638@va45s03.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung

Browse pgsql-general by date

  From Date Subject
Next Message John P. Looney 2001-10-10 14:18:41 Embedded postgres ?
Previous Message Eric D Nielsen 2001-10-10 13:50:02 Re: Problems installing with --with-python