Re: Linux: more cores = less concurrency. - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: Linux: more cores = less concurrency.
Date
Msg-id 4DA3E082.5040903@krogh.cc
Whole thread Raw
In response to Re: Linux: more cores = less concurrency.  (James Cloos <cloos@jhcloos.com>)
List pgsql-performance
On 2011-04-11 22:39, James Cloos wrote:
>>>>>> "GA" == Glyn Astill<glynastill@yahoo.co.uk>  writes:
> GA>  I was hoping someone had seen this sort of behaviour before,
> GA>  and could offer some sort of explanation or advice.
>
> Jesper's reply is probably most on point as to the reason.
>
> I know that recent Opterons use some of their cache to better manage
> cache-coherency.  I presum recent Xeons do so, too, but perhaps yours
> are not recent enough for that?

Better cache-coherence also benefits, but it does nothing to
the fact that remote DRAM fetches is way more expensive
than local ones. (Hard numbers to get excact nowadays).

--
Jesper

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Linux: more cores = less concurrency.
Next
From: Dieter Rehbein
Date:
Subject: performance problem with LIMIT (order BY in DESC order). Wrong index used?