| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Wakeup WALWriter as needed for asynchronous commit performance. |
| Date: | 2011-11-13 09:04:57 |
| Message-ID: | E1RPVzl-0002E2-Ox@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2011-11-13 12:58:18 | pgsql: Applied patch by Zoltan to fix copy&paste bug in ecpg's sqlda ha |
| Previous Message | Tom Lane | 2011-11-12 23:49:26 | pgsql: In plpgsql, allow foreign tables to define row types. |