Feature compatibility v5.9.0

Suggest edits

Server feature/commit scope interoperability

Not all server features work with all commit scopes. This table shows the ones that interoperate.

Async
(default)
Parallel
Apply 		Transaction
Streaming 		Single
Decoding
Worker
Group Commit ⛔︎ ❌ ❌❗️ ✅
CAMO ⛔︎ ✅ ❌ ❌
Lag Control ✅ ✅ ✅ ✅
Synchronous Commit ⛔︎ ✅ ✅ ✅

Legend:    ⛔︎ Not applicable    ❌ Does not interoperate    ✅ Interoperates

Notes

⛔︎ : The Async column in the table represents PGD without a synchronous commit scope in use. Lag Control isn't a synchronous commit scope. It's a controlling commit scope and is therefore available with asynchronous operations.

❗️ : Attempting to use Group Commit and Transaction Streaming presents a warning. The warning suggests that you disable transaction streaming, and the transaction appears to take place. In the background, Group Commit was disabled to allow the transaction to occur.

Commit scope/commit scope interoperability

Although you can't mix commit scopes, you can combine rules with an AND operator. This table shows where commit scopes can be combined.

Group
Commit		CAMO Lag
Control 		Synchronous
Commit
Group Commit ⛔︎ ❌ ✅ ✅
CAMO ❌ ⛔︎ ✅ ❌
Lag Control ✅ ✅ ⛔︎ ✅
Synchronous Commit ✅ ❌ ✅ ⛔︎

Legend:    ⛔︎ Not applicable    ❌ Does not combine    ✅ Combines

Notes

Each commit scope implicitly works with itself.

← Prev

Use of table access methods (TAMs) in PGD

↑ Up

Application use

Next →

DDL replication