XEON familiy 5000, 5100 or 5300?

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-general(at)postgresql(dot)org>
Subject: XEON familiy 5000, 5100 or 5300?
Date: 2007-01-13 08:43:16
Message-ID: 6C0CF58A187DA5479245E0830AF84F4218CD2B@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2007-01-13 09:08:23 Re: PostgreSQL Connections?
Previous Message Shane Ambler 2007-01-13 08:34:40 Re: PostgreSQL Connections?