Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit91215f6

Browse files
committed
Document that increasing the number of checkpoints segments or
checkpoint timeout can incrase the time needed for crash recovery, persuggestion from Simon.
1 parent4309a7d commit91215f6

File tree

1 file changed

+7
-4
lines changed

1 file changed

+7
-4
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.166 2008/02/16 21:14:08 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.167 2008/03/05 16:59:10 momjian Exp $ -->
22

33
<chapter Id="runtime-config">
44
<title>Server Configuration</title>
@@ -1584,9 +1584,10 @@ SET ENABLE_SEQSCAN TO OFF;
15841584
</indexterm>
15851585
<listitem>
15861586
<para>
1587-
Maximum distance between automatic WAL checkpoints, in log
1588-
file segments (each segment is normally 16 megabytes). The
1589-
default is three segments.
1587+
Maximum number of log file segments between automatic WAL
1588+
checkpoints (each segment is normally 16 megabytes). The default
1589+
is three segments. Increasing this parameter can increase the
1590+
amount of time needed for crash recovery.
15901591
This parameter can only be set in the <filename>postgresql.conf</>
15911592
file or on the server command line.
15921593
</para>
@@ -1602,6 +1603,8 @@ SET ENABLE_SEQSCAN TO OFF;
16021603
<para>
16031604
Maximum time between automatic WAL checkpoints, in
16041605
seconds. The default is five minutes (<literal>5min</>).
1606+
Increasing this parameter can increase the amount of time needed
1607+
for crash recovery.
16051608
This parameter can only be set in the <filename>postgresql.conf</>
16061609
file or on the server command line.
16071610
</para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp