Skip site navigation (1) Skip section navigation (2)

Re: Pg on SMP half-powered

From: Colin Strickland <cms(at)sift(dot)co(dot)uk>
To: Víctor Romero <romero(at)kde(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pg on SMP half-powered
Date: 2001-07-06 09:36:38
Message-ID: 200107060936.f669ac905171@mongoose.office.sift.co.uk (view raw or flat)
Thread:
Lists: 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");'

In response to

pgsql-hackers by date

Next:From: Jean-Francois LevequeDate: 2001-07-06 09:37:50
Subject: Database Users Management and Privileges
Previous:From: Zeugswetter Andreas SBDate: 2001-07-06 09:04:32
Subject: AW: Re: Backup and Recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group