pgbench - Mailing list pgsql-general

From Peter Keller
Subject pgbench
Date
Msg-id 200110101414.QAA05638@va45s03.bayern.de
Whole thread Raw
List 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.Keller@bvv.bayern.de
 80538 Muenchen   :  web: http://www.bayern.de/vermessung

pgsql-general by date:

Previous
From: bga@bajor.mug.org (Billy G. Allie)
Date:
Subject: Re: pypgsql 'create database' problem
Next
From: "Mihai Gheorghiu"
Date:
Subject: Session identifier