Обсуждение: pgsql: Wakeup WALWriter as needed for asynchronous commit performance.

Поиск
Список
Период
Сортировка

pgsql: Wakeup WALWriter as needed for asynchronous commit performance.

От
Simon Riggs
Дата:
Wakeup WALWriter as needed for asynchronous commit performance.
Previously we waited for wal_writer_delay before flushing WAL. Now
we also wake WALWriter as soon as a WAL buffer page has filled.
Significant effect observed on performance of asynchronous commits
by Robert Haas, attributed to the ability to set hint bits on tuples
earlier and so reducing contention caused by clog lookups.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4de82f7d7c50a81ec8e70e2cb0ab413ab9134c0b

Modified Files
--------------
src/backend/access/transam/xlog.c  |   33 ++++++++++++++++++++++++++++++++-
src/backend/postmaster/walwriter.c |   27 ++++++++++-----------------
src/include/access/xlog.h          |    2 ++
3 files changed, 44 insertions(+), 18 deletions(-)