commit_siblings

A server parameter specifying the minimum number of concurrent transactions for commit_delay to be applied

commit_siblings is a configuration parameter specifying the minimum number of concurrent open transactions required before performing a WAL flush when commit_delay is set to a non-zero value.

commit_siblings was added in PostgreSQL 7.1.

Default value

The default value for commit_siblings is: 5.

Usage

commit_siblings is only effective if commit_delay is set to a non-zero value.

In general a larger value is preferable for commit_siblings as this makes it more likely that at least one other transaction will become ready to commit during the delay interval.

Change history

Categories

GUC configuration item, Transactions, WAL

See also

commit_delay