diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-03-05 17:00:40 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-03-05 17:00:40 +0000 |
| commit | 0f8a34a73052950eb434618cef8d61f0ffef8b9e (patch) | |
| tree | 4fa306e5c96bdbde0de8e93c902ecae939eac3be /doc/src | |
| parent | 267d90b82cee32597b1b5af33dcce12fa3c2b62c (diff) | |
| download | postgresql-0f8a34a73052950eb434618cef8d61f0ffef8b9e.tar.gz postgresql-0f8a34a73052950eb434618cef8d61f0ffef8b9e.zip | |
Document that increasing the number of checkpoints segments or
checkpoint timeout can incrase the time needed for crash recovery, per
suggestion from Simon.
Diffstat (limited to 'doc/src')
| -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 e910706a313..0227c4461bb 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.164 2008/02/02 23:29:12 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.164.2.1 2008/03/05 17:00:40 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> |