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

From Víctor Romero
Subject Pg on SMP half-powered
Date
Msg-id 200107051658.f65GwPI29235@programasdefuturo.com
Whole thread Raw
Responses Re: Pg on SMP half-powered  (The Hermit Hacker <scrappy@hub.org>)
Re: Pg on SMP half-powered  (Lamar Owen <lamar.owen@wgcr.org>)
List pgsql-hackers
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:






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: Strange query execution time
Next
From: "P. Dwayne Miller"
Date:
Subject: Using Explain