pgsql: Reduce sinval synchronization overhead.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема pgsql: Reduce sinval synchronization overhead.
Дата
Msg-id E1Qmu1e-0002sR-1c@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgsql: Move new pgbench options to correct section of --help output.
Следующее
От: Bruce Momjian
Дата:
Сообщение: pgsql: Fix pg_update to properly test for the data directory's existenc