Обсуждение: FW: x206-x226
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
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 Ghzmain memory 1.25 GB 4 GBdiscs 1 x ATA 7200 RPM 2 x SCSI RAID1 10000RPMLINUX 2.6 (SUSE 9) samePGSQL 7.4 samepostgresql.conf attached sameWe have bij means of an informix-4GL program done the following test:create table : name char(18)adres char(20)key integercreate 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 4delete record (key goes from 1 to 10000) 6 41This 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 wecan start our investigations?RegardsHenk Sanders