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