pgsql: Reduce sinval synchronization overhead. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Reduce sinval synchronization overhead.
Date
Msg-id E1Qmu1e-0002sR-1c@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Reduce sinval synchronization overhead.

Testing shows that the overhead of acquiring and releasing
SInvalReadLock and msgNumLock on high-core count boxes can waste a lot
of CPU time and hurt performance.  This patch adds a per-backend flag
that allows us to skip all that locking in most cases.  Further
testing shows that this improves performance even when sinval traffic
is very high.

Patch by me.  Review and testing by Noah Misch.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b4fbe392f8ff6ff1a66b488eb7197eef9e1770a4

Modified Files
--------------
src/backend/storage/ipc/sinvaladt.c |   62 ++++++++++++++++++++++++++++++----
1 files changed, 54 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Move new pgbench options to correct section of --help output.
Next
From: Bruce Momjian
Date:
Subject: pgsql: Fix pg_update to properly test for the data directory's existenc