NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit2c8a4e9

committed

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

WALSender now woken up after each background flush by WALwriter, avoidingmulti-second replication delay for an all-async commit workload.Replication delay reduced from 7s with default settings to 200ms and oftenmuch less, allowing significantly reduced data loss at failover.Andres Freund and Simon Riggs

1 parentb50991e commit2c8a4e9Copy full SHA for 2c8a4e9

File tree

1 file changed

-0

lines changed

src/backend/access/transam
- xlog.c

1 file changed

-0

lines changed

`‎src/backend/access/transam/xlog.c`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2271,6 +2271,13 @@ XLogBackgroundFlush(void)`
`2271`	`2271`
`2272`	`2272`	`END_CRIT_SECTION();`
`2273`	`2273`
	`2274`	`+/*`
	`2275`	`+ * If we wrote something then we have something to send to standbys also,`
	`2276`	`+ * otherwise the replication delay become around 7s with just async commit.`
	`2277`	`+ */`
	`2278`	`+if (wrote_something)`
	`2279`	`+WalSndWakeup();`
	`2280`	`+`
`2274`	`2281`	`returnwrote_something;`
`2275`	`2282`	`}`
`2276`	`2283`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit2c8a4e9

File tree

1 file changed

1 file changed

`‎src/backend/access/transam/xlog.c`

0 commit comments