x206-x225

From: "H(dot)J(dot) Sanders" <hjs(at)rmax(dot)nl>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: x206-x225
Date: 2006-03-10 09:50:20
Message-ID: GMEAJIDMNDKCIHMMHDFLCEKHDHAA.hjs@rmax.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello list.

We have compared 2 IBM x servers:

IBM X206
IBM X226
----------------------
-------------------
processor Pentium 4 3.2 Ghz
Xeon 3.0 Ghz
main memory 1.25 GB
4 GB
discs 2 x SCSI RAID1 10000RPM 1 x
ATA 7200 RPM

LINUX 2.6 (SUSE 9)
same
PGSQL 7.4
same
postgresql.conf attached
same

We have bij means of an informix-4GL program done the following test:

create table : name char(18)
adres char(20)
key integer

create index on (key)
Time
at X206 Time at X226
----------------
---- ------------------

insert record (key goes from 1 to 10000) 6 sec.
41 sec.
select record (key goes from 1 to 10000) 4
4
delete record (key goes from 1 to 10000) 6
41

This is ofcourse a totally unexpected results (you should think off the
opposite).

Funny is that the select time is the same for both machines.

Does anybody has any any idea what can cause this strange results or where
we
can start our investigations?

Regards

Henk Sanders

Attachment Content-Type Size
postgresql.conf-74 application/octet-stream 8.0 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message H.J. Sanders 2006-03-10 09:59:46 FW: x206-x226
Previous Message Richard Huxton 2006-03-10 09:40:47 Re: Process Time X200