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(-)
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. |