commit_delay
commit_delay is a configuration parameter for adding a time delay before a WAL flush is initiated.
commit_delay was added in PostgreSQL 7.1.
Default value
The default value for commit_delay is: 0 (disabled).
Usage
NOTE: commit_delay is generally not regarded as an effective or easy parameter to tune, and may only bring performance benefits in certain very specific situations, while risking an overall performance slowdown.
If set to a non-zero value, commit_delay makes it possible for a larger number of transactions to commit via a single WAL flush, improving system throughput. However it also increases latency by up to the specified value for each WAL flush.
commit_delay is only of practical use if mulitple transactions (at least the number specified by commit_siblings, default 5) become ready to commit within the interval specified.
Change history
- PostgreSQL 9.3
- PostgreSQL 7.1
- added (commit 74151052)
References
- PostgreSQL documentation: commit_delay