x206-x225 - Mailing list pgsql-performance

From H.J. Sanders
Subject x206-x225
Date
Msg-id GMEAJIDMNDKCIHMMHDFLCEKHDHAA.hjs@rmax.nl
Whole thread Raw
Responses Re: x206-x225  (Richard Huxton <dev@archonet.com>)
List 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

pgsql-performance by date:

Previous
From: Ragnar
Date:
Subject: Re: Process Time X200
Next
From: "H.J. Sanders"
Date:
Subject: FW: x206-x226