diff options
| author | Andres Freund <andres@anarazel.de> | 2015-03-15 17:37:07 +0100 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2015-03-15 17:37:07 +0100 |
| commit | a0f5954af19ddcfea946b15744f2006a789dc4bd (patch) | |
| tree | f1804d6c5e464c1c22c1022dc7525b896fac1071 /doc/src | |
| parent | 241f088f3632814fe9dbd5bcbc509ec42a268d01 (diff) | |
Increase max_wal_size's default from 128MB to 1GB.
The introduction of min_wal_size & max_wal_size in 88e982302684 makes it
feasible to increase the default upper bound in checkpoint
size. Previously raising the default would lead to a increased disk
footprint, even if more segments weren't beneficial. The low default of
checkpoint size is one of common performance problem users have thus
increasing the default makes sense. Setups where the increase in
maximum disk usage is a problem will very likely have to run with a
modified configuration anyway.
Discussion: 54F4EFB8.40202@agliodbs.com,
CA+TgmoZEAgX5oMGJOHVj8L7XOkAe05Gnf45rP40m-K3FhZRVKg@mail.gmail.com
Author: Josh Berkus, after a discussion involving lots of people.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/wal.sgml | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d0f43c64af3..b30c68dc138 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -2430,7 +2430,7 @@ include_dir 'conf.d' checkpoints. This is a soft limit; WAL size can exceed <varname>max_wal_size</> under special circumstances, like under heavy load, a failing <varname>archive_command</>, or a high - <varname>wal_keep_segments</> setting. The default is 128 MB. + <varname>wal_keep_segments</> setting. The default is 1 GB. Increasing this parameter can increase the amount of time needed for crash recovery. This parameter can only be set in the <filename>postgresql.conf</> diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml index b57749fdbc3..f4083c3fe57 100644 --- a/doc/src/sgml/wal.sgml +++ b/doc/src/sgml/wal.sgml @@ -475,7 +475,7 @@ linkend="guc-checkpoint-timeout"> seconds, or if <xref linkend="guc-max-wal-size"> is about to be exceeded, whichever comes first. - The default settings are 5 minutes and 128 MB, respectively. + The default settings are 5 minutes and 1 GB, respectively. If no WAL has been written since the previous checkpoint, new checkpoints will be skipped even if <varname>checkpoint_timeout</> has passed. (If WAL archiving is being used and you want to put a lower limit on how |