pgsql: Reduce sinval synchronization overhead.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Reduce sinval synchronization overhead.
Date: 2011-07-29 20:51:18
Message-ID: E1Qmu1e-0002sR-1c@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2011-07-30 05:50:57 pgsql: Fix pg_update to properly test for the data directory's existenc
Previous Message Robert Haas 2011-07-29 20:44:39 pgsql: Move new pgbench options to correct section of --help output.