Search Postgresql Archives

Re: XEON familiy 5000, 5100 or 5300?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx)


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux