pgsql: Wake WALSender to reduce data loss at failover for async commit.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Wake WALSender to reduce data loss at failover for async commit.
Date: 2012-06-07 18:26:20
Message-ID: E1SchPY-0004f1-Sb@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2012-06-07 20:46:36 pgsql: Do unlocked prechecks in bufmgr.c loops that scan the whole buff
Previous Message Simon Riggs 2012-06-07 18:25:21 pgsql: Wake WALSender to reduce data loss at failover for async commit.