Re: Pg on SMP half-powered

What is the postgres process doing?  what does iostat show for disk I/O?
from reading this, you are comparing apples->oranges ... are the drives
the same on the non-SMP as the SMP?  amount of RAM?  speed of CPUs?  hard
drive controllers with same amount of cache on them? etc, etc, etc ...

On Thu, 5 Jul 2001, [iso-8859-1] V�ctor Romero wrote:

>
>
>  Hello, hackers!
>
>
>  I am running postgresql 7.1 on a SMP Linux box. It runs, but it never pass a
> loadavg of 0.4, no matter how I try to overload the system.
>
>  The same configuration, the same executable, the same test on a non-SMP
> machine gives a loadavg of 19.
>
>  That means that a Xeon SMP box with 1Gb of RAM goes slowlier than a weak
> CPU, with the same postgres, the same configuration, and the same test.
>
>  Anybody knows what is happening? Is there something to do on a SMP machine
> for it to run? I tried with lots of shared memory, and with "commit_delay=0",
> but nothing worked.
>
>  Yours:
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org