FW: x206-x226

"H.J. Sanders" <hjs@xxxxxxx> · Fri, 10 Mar 2006 10:59:46 +0100

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@xxxxxxxxxxxxxx 
[mailto:pgsql-performance-owner@xxxxxxxxxxxxxx]Namens H.J. 
Sanders
Verzonden: vrijdag 10 maart 2006 10:50
Aan: 
pgsql-performance@xxxxxxxxxxxxxx
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

Attachment:
postgresql.conf-74

Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly