Re: XEON familiy 5000, 5100 or 5300? - Mailing list pgsql-general

From Shane Ambler
Subject Re: XEON familiy 5000, 5100 or 5300?
Date
Msg-id 45A8D3E8.1040800@007Marketing.com
Whole thread Raw
In response to XEON familiy 5000, 5100 or 5300?  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List 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@007Marketing.com

Get Sheeky @ http://Sheeky.Biz

pgsql-general by date:

Previous
From: "dfx"
Date:
Subject: automatic build of return type
Next
From: Richard Huxton
Date:
Subject: Re: FK Constraint on index not PK