Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Wake WALSender to reduce data loss at failover for async commit. - Mailing list pgsql-committers

From Simon Riggs
Subject pgsql: Wake WALSender to reduce data loss at failover for async commit.
Date
Msg-id E1SchPY-0004f1-Sb@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Wake WALSender to reduce data loss at failover for async commit.
WALSender now woken up after each background flush by WALwriter, avoiding
multi-second replication delay for an all-async commit workload.
Replication delay reduced from 7s with default settings to 200ms, allowing
significantly reduced data loss at failover.

Andres Freund and Simon Riggs

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/090e8a984cf1a8a3ef7f6db6dc919f843902d80c

Modified Files
--------------
src/backend/access/transam/xlog.c |    9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: pgsql: Wake WALSender to reduce data loss at failover for async commit.
Next
From: Tom Lane
Date:
Subject: pgsql: Do unlocked prechecks in bufmgr.c loops that scan the whole buff