Re: Possible performance regression in version 10.1 with pgbench read-write tests.

Thomas Munro <thomas.munro@enterprisedb.com>

From: Thomas Munro <thomas.munro@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>, Mithun Cy <mithun.cy@enterprisedb.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, Amit Kapila <amit.kapila16@gmail.com>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-07-23T04:56:56Z
Lists: pgsql-hackers
On Mon, Jul 23, 2018 at 3:40 PM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> I did some testing on 2-node, 4-node and 8-node systems running Linux
> 3.10.something (slightly newer but still ancient).  Only the 8-node
> box (= same one Mithun used) shows the large effect (the 2-node box
> may be a tiny bit faster patched but I'm calling that noise for now...
> it's not slower, anyway).

(I forgot to add that the 4 node system that showed no change is POWER
architecture.)

-- 
Thomas Munro
http://www.enterprisedb.com


Commits

  1. Pad semaphores to avoid false sharing.