diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-03-05 16:59:10 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-03-05 16:59:10 +0000 |
| commit | 91215f62411a9801c15e8b6890972cb3497002a1 (patch) | |
| tree | b27c9e80c82042521a5e953fe4ac6ae08d14bac1 | |
| parent | 4309a7dd9954115774ac6e962f4851cebadc9dbe (diff) | |
Document that increasing the number of checkpoints segments or
checkpoint timeout can incrase the time needed for crash recovery, per
suggestion from Simon.
| -rw-r--r-- | doc/src/sgml/config.sgml | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ceaeb205d91..2e8d62e2923 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.166 2008/02/16 21:14:08 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.167 2008/03/05 16:59:10 momjian Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -1584,9 +1584,10 @@ SET ENABLE_SEQSCAN TO OFF; </indexterm> <listitem> <para> - Maximum distance between automatic WAL checkpoints, in log - file segments (each segment is normally 16 megabytes). The - default is three segments. + Maximum number of log file segments between automatic WAL + checkpoints (each segment is normally 16 megabytes). The default + is three segments. Increasing this parameter can increase the + amount of time needed for crash recovery. This parameter can only be set in the <filename>postgresql.conf</> file or on the server command line. </para> @@ -1602,6 +1603,8 @@ SET ENABLE_SEQSCAN TO OFF; <para> Maximum time between automatic WAL checkpoints, in seconds. The default is five minutes (<literal>5min</>). + Increasing this parameter can increase the amount of time needed + for crash recovery. This parameter can only be set in the <filename>postgresql.conf</> file or on the server command line. </para> |