diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-02-05 23:37:43 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-02-05 23:37:43 +0000 |
| commit | 4b113d9cdc8654e3f979497e057c7f9062bfa612 (patch) | |
| tree | d98950e743d1bf88332b49069a9206ae9ef72d1e /doc/src | |
| parent | ef51fa505ca6433aaf4e7826a79f665ffecd241a (diff) | |
| download | postgresql-4b113d9cdc8654e3f979497e057c7f9062bfa612.tar.gz postgresql-4b113d9cdc8654e3f979497e057c7f9062bfa612.zip | |
Document that archive_timeout will force new WAL files even if a single
checkpoint has happened, and recommend adjusting checkpoint_timeout to
reduce the impact of this.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d6c739d96b3..a5f520057e3 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.249 2010/02/03 17:25:05 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.250 2010/02/05 23:37:43 momjian Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -1739,7 +1739,11 @@ archive_command = 'copy "%p" "C:\\server\\archivedir\\%f"' # Windows server to switch to a new WAL segment file periodically. When this parameter is greater than zero, the server will switch to a new segment file whenever this many seconds have elapsed since the last - segment file switch. Note that archived files that are closed early + segment file switch, and there has been any database activity, + including a single checkpoint. (Increasing + <varname>checkpoint_timeout</> will reduce unnecessary + checkpoints on an idle system.) + Note that archived files that are closed early due to a forced switch are still the same length as completely full files. Therefore, it is unwise to use a very short <varname>archive_timeout</> — it will bloat your archive |