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
- PostgreSQL 7.1
- added (commit 9c993658)
References
- PostgreSQL documentation: commit_siblings