Re: [HACKERS] Fix performance of generic atomics - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] Fix performance of generic atomics
Date
Msg-id CANP8+jLAvKiQFP84OXM3kuMkipj9Tqn6aEO0163WjP1fGfTneQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Fix performance of generic atomics  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Fix performance of generic atomics  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 5 September 2017 at 21:23, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Jeff Janes <jeff.janes@gmail.com> writes:
>> What scale factor and client count? How many cores per socket?  It looks
>> like Sokolov was just starting to see gains at 200 clients on 72 cores,
>> using -N transaction.

...
> Moreover, it matters which primitive you're testing, on which platform,
> with which compiler, because we have a couple of layers of atomic ops
> implementations.
...

I think Sokolov was aiming at 4-socket servers specifically, rather
than as a general performance gain.

If there is no gain on 2-socket, at least there is no loss either.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] document and use SPI_result_code_string()
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] <> join selectivity estimate question