Feature compatibility

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	Using with transaction streaming	Decoding worker
Group commit	Not applicable	Does not interoperate	Does not interoperate❗️	Interoperates
Commit At Most Once	Not applicable	Interoperates	Does not interoperate	Does not interoperate
Lag Control	Interoperates	Interoperates	Interoperates	Interoperates
Synchronous Commit	Not applicable	Interoperates	Interoperates	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	Commit At Most Once	Lag Control	Synchronous Commit
Group commit	Not applicable	Does not combine	Combines	Combines
Commit At Most Once	Does not combine	Not applicable	Combines	Does not combine
Lag Control	Combines	Combines	Not applicable	Combines
Synchronous Commit	Combines	Does not combine	Combines	Not applicable

Notes

Each commit scope implicitly works with itself.