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] Vctor 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(at)postgresql(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org