Re: Pg on SMP half-powered - Mailing list pgsql-hackers

From Colin Strickland
Subject Re: Pg on SMP half-powered
Date
Msg-id 200107060936.f669ac905171@mongoose.office.sift.co.uk
Whole thread Raw
In response to Re: Pg on SMP half-powered  (Víctor Romero <romero@kde.org>)
List pgsql-hackers
On 06 Jul 2001 10:52:33 +0200, Víctor Romero wrote:

>       (about comparing apples with oranges) Yes, I know. More exactly, I am 
> comparing a F-1 car with a bike, bike run faster, and I ask on the F-1 
> experts mailing list why.
> 
>       RAM: 1Gb on the SMP machine. 128Mb on the non-SMP machine.
> 
>       Speed: 400MHz on the non-SMP machine. 550 on the SMP one.
> 
>            The SMP machine is far away better than the non-SMP one. Same OS, 
> same distro, same Postgres, same test, and a cheap non-SMP machine 
> outperforms a very expensive HP SMP server. It looks a interblocking stuff, 
> due to all the postmasters are sleeping but one, meanwhile on the non-SMP 
> they runs concurently. Does anybody knows what is happening?
> 
> 
>  Yours:


What kernel version? 2.4.x has had problems with mtrr on SMP Xeon
systems and we had to upgrade to 2.2.19 to get 2.2.x to use the L2 cache
on newer Xeon CPU's. The default redhat kernel had no idea what they
were, according to our sysadmin here and they ended up running with L2
cahce disabled. And then we ran into problems with bigmem with RedHat's
2.2.19 upgrade and decided that the better route was to complile our own
, ensuring all of your hardware gets explicitly supported properly.


-- 
Colin M Strickland  perl -e'print "\n",map{chr(ord()-3)}(reverse split
//,"\015%vhlwlqxpprF#ir#uhzrS#hkw#jqlvvhqudK%#\015\015nx".
"1rf1wilv1zzz22=swwk###369<#84<#:44#77.={di##339<#84<#:44#77.=ohw\015]".
"K9#4VE#/ORWVLUE#/whhuwV#dlurwflY#334#/wilV\015uhsrohyhG#ehZ#urlqhV");'


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: Backup and Recovery
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Backup and Recovery