FW: [PERFORM] x206-x226

[H.J. Sanders]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]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)                                                                         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

postgresql.conf-74
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster