PostgreSQL handles each connection in a dedicated process, so you won't get
better performance for a single connection by adding more CPUs (I mean,
beyond the benefit of having the postmaster and the specific connection
running in separate CPUs). This means that a query will not be resolved by
more than one CPU. What you will get is better performance for multiple
connections.
On Sat January 13 2007 05:43, Philippe Lang wrote:
> Hi,
>
> I'm about to buy a few new servers, and I'm trying to determine if I
> should buy XEON family 5000, 5100 or 5300 processors.
>
> For about the same price, I can have:
>
> 2 Dual-Core Intel Xeon 5060, 3.2 GHz, 4MB
> 2 Dual-Core Intel Xeon 5130, 2.0 GHz, 4MB
> 2 Quad-Core Intel Xeon 5310, 1.6 GHz, 4MB
>
> I have a few queries that take about 4 minutes each to complete on a
> single Pentium 4, and all of them are CPU-bound, with the whole database
> in RAM. With the new system, I expect a performance boost, of course!
>
> If I'm not wrong, a single postgresql sql query cannot be spread over
> two processors, but can it be spread over multiple cores? If that's
> true, does that mean the best CPU would be the last one, although the
> clock is lower that the one of the other processors?
>
> Thanks for the infos,
>
> Cheers,
>
> ---------------
> Philippe Lang
> Attik System
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Juan Jose Comellas
(juanjo@comellas.com.ar)