Avoid unnecessary shm writes in Parallel Hash Join.
authorThomas Munro <[email protected]>
Sun, 26 Jan 2020 23:52:08 +0000 (12:52 +1300)
committerThomas Munro <[email protected]>
Mon, 27 Jan 2020 02:07:03 +0000 (15:07 +1300)
commit3e4818e9dd5be294d97ca67012528cb1c0b0ccaa
tree8e4ee2c7c8eab05100c19d0727ed91f9cb1ddb07
parent10a525230fb18331dbcfd6a4a7248d76f55c331c
Avoid unnecessary shm writes in Parallel Hash Join.

Currently, Parallel Hash Join cannot be used for full/right joins,
so there is no point in setting the match flag.  It turns out that
the cache coherence traffic generated by those writes slows down
large systems running many-core joins, so let's stop doing that.
In future, if we need to use match bits in parallel joins, we might
want to consider setting them only if not already set.

Back-patch to 11, where Parallel Hash Join arrived.

Reported-by: Deng, Gang
Discussion: https://postgr.es/m/0F44E799048C4849BAE4B91012DB910462E9897A%40SHSMSX103.ccr.corp.intel.com
src/backend/executor/nodeHashjoin.c