NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitfe546f3

committed

Don't wait for the commit record to be replicated if we wrote no WAL.

When using synchronous replication, we waited for the commit record to bereplicated, but if we our transaction didn't write any other WAL records,that's not required because we don't even flush the WAL locally to disk inthat case. This lead to long waits when committing a transaction that onlymodified a temporary table. Bug spotted by Thom Brown.

1 parentcf714c8 commitfe546f3Copy full SHA for fe546f3

File tree

1 file changed

-1

lines changed

src/backend/access/transam
- xact.c

1 file changed

-1

lines changed

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

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1168,7 +1168,8 @@ RecordTransactionCommit(void)`
`1168`	`1168`	`* Note that at this stage we have marked clog, but still show as running`
`1169`	`1169`	`* in the procarray and continue to hold locks.`
`1170`	`1170`	`*/`
`1171`		`-SyncRepWaitForLSN(XactLastRecEnd);`
	`1171`	`+if (wrote_xlog)`
	`1172`	`+SyncRepWaitForLSN(XactLastRecEnd);`
`1172`	`1173`
`1173`	`1174`	`/* Reset XactLastRecEnd until the next transaction writes something */`
`1174`	`1175`	`XactLastRecEnd.xrecoff=0;`

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!

Commitfe546f3

File tree

1 file changed

1 file changed

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

0 commit comments