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