From: H.J. Sanders <hjs@rmax.nl>
To: pgsql-performance@postgresql.org
Subject: FW: x206-x226
Date: Fri, 10 Mar 2006 10:59:46 +0100
Message-ID: <GMEAJIDMNDKCIHMMHDFLIEKHDHAA.hjs@rmax.nl> (raw)
Hello list.
Reading my own e-mail I notice I made a very important mistake.
The X206 has 1 x ATA 7200 RPM
The X226 has 2 x SCSI RAID1 10000RPM
I corrected it below.
Sorry .
Henk Sanders
-----Oorspronkelijk bericht-----
Van: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]Namens H.J. Sanders
Verzonden: vrijdag 10 maart 2006 10:50
Aan: pgsql-performance@postgresql.org
Onderwerp: [PERFORM] x206-x225
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 1 x ATA 7200 RPM
2 x SCSI RAID1 10000RPM
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)
Ti
me 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
Attachments:
postgresql.conf-74 (application/octet-stream, 8.0K) downloadATT00011.txt (text/plain, 274B) download
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: hjs@rmax.nl
Subject: Re: FW: x206-x226
In-Reply-To: <GMEAJIDMNDKCIHMMHDFLIEKHDHAA.hjs@rmax.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox