Re: XEON familiy 5000, 5100 or 5300?

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: XEON familiy 5000, 5100 or 5300?
Date: 2007-01-13 12:43:20
Message-ID: 45A8D3E8.1040800@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Philippe Lang wrote:

> 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

No - a *core* is another cpu, basically you will have 2 or 4 cpu's in
the one physical package.

HT creates 2 virtual cpu's sharing the same cpu resources but the cores
are seperate cpu's in themselves.

The Quad-core will only benefit you more if you have more users running
queries at the same time. Each core can run a query at the same time
without slowing the others down (allowing for disk access/FSB limits).

--

Shane Ambler
pgSQL(at)007Marketing(dot)com

Get Sheeky @ http://Sheeky.Biz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-01-13 13:10:45 Re: FK Constraint on index not PK
Previous Message dfx 2007-01-13 10:14:48 automatic build of return type