Re: XEON familiy 5000, 5100 or 5300?

From: Juan Jose Comellas <juanjo(at)comellas(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Cc: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
Subject: Re: XEON familiy 5000, 5100 or 5300?
Date: 2007-01-14 15:33:34
Message-ID: 200701141233.35403.juanjo@comellas.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)comellas(dot)com(dot)ar)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-01-14 16:27:21 Re: Remove diacritical marks in SQL
Previous Message Stéphane Schildknecht 2007-01-14 14:56:10 Re: FK Constraint on index not PK