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

From Claudio Freire
Subject Re: Linux: more cores = less concurrency.
Date
Msg-id BANLkTimaTUHHT9oO24zNgqxVhQUBiPDKWA@mail.gmail.com
Whole thread Raw
In response to Re: Linux: more cores = less concurrency.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Tue, Apr 12, 2011 at 6:40 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>
> Well, that pretty much clinches it.  Your RAM access tops out at 16
> processors.  It appears that your processors are spending most of
> their time waiting for and contending for the RAM bus.

It tops, but it doesn't drop.

I'd propose that the perceived drop in TPS is due to cache contention
- ie, more processes fighting for the scarce cache means less
efficient use of the (constant upwards of 16 processes) bandwidth.

So... the solution would be to add more servers, rather than just sockets.
(or a server with more sockets *and* more bandwidth)

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Linux: more cores = less concurrency.
Next
From: "F. BROUARD / SQLpro"
Date:
Subject: Re: Linux: more cores = less concurrency.