|
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:
postgresql.conf-74
Description: Binary data
