diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-02-26 23:36:24 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2011-02-26 23:38:25 +0200 |
| commit | be6668d6eff6a03455b48fa8ce1a397ff5bae788 (patch) | |
| tree | 0884d65268f27633e66d94a926c0b5a3fe9600ee /doc/src | |
| parent | 42e5223648e7e56f8041bed329929dbd5529ea92 (diff) | |
| download | postgresql-be6668d6eff6a03455b48fa8ce1a397ff5bae788.tar.gz postgresql-be6668d6eff6a03455b48fa8ce1a397ff5bae788.zip | |
Increase the default for wal_sender_delay from 200ms to 1s. Now that WAL
sender is immediately woken up by transaction commit, there's no need to
wake up so aggressively.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index cee09c76815..46ffbff1087 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1939,8 +1939,11 @@ SET ENABLE_SEQSCAN TO OFF; Specifies the delay between activity rounds for WAL sender processes. In each round the WAL sender sends any WAL accumulated since the last round to the standby server. It then sleeps for - <varname>wal_sender_delay</> milliseconds, and repeats. The default - value is 200 milliseconds (<literal>200ms</>). + <varname>wal_sender_delay</> milliseconds, and repeats. The sleep + is interrupted by transaction commit, so the effects of a committed + transaction are sent to standby servers as soon as the commit + happens, regardless of this setting. The default value is one second + (<literal>1s</>). Note that on many systems, the effective resolution of sleep delays is 10 milliseconds; setting <varname>wal_sender_delay</> to a value that is not a multiple of 10 might have the same results as setting it to |