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

From Claudio Freire
Subject Re: Linux: more cores = less concurrency.
Date
Msg-id BANLkTi=Qv8mOzD_PbdWcHwNkZcMX-PbwFw@mail.gmail.com
Whole thread Raw
In response to Re: Linux: more cores = less concurrency.  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
On Fri, Apr 15, 2011 at 12:42 AM, Scott Carey <scott@richrelevance.com> wrote:
> I do know that dual-pivot quicksort provably causes fewer swaps (but the
> same # of compares) as the usual single-pivot quicksort.  And swaps are a
> lot slower than you would expect due to the effects on processor caches.
> Therefore it might help with multiprocessor scalability by reducing
> memory/cache pressure.

I agree, and it's quite non-disruptive - ie, a drop-in replacement for
quicksort, whereas mergesort or timsort both require bigger changes
and heavier profiling.

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Linux: more cores = less concurrency.
Next
From: Václav Ovsík
Date:
Subject: Re: poor execution plan because column dependence