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

Commit857433b

Browse files
committed
In documentaiton, clarify which commands have reduced WAL volume for
wal_level = minimum.Backpatch to 9.1 and 9.0.
1 parent1318f1a commit857433b

File tree

1 file changed

+12
-5
lines changed

1 file changed

+12
-5
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 12 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1420,11 +1420,18 @@ SET ENABLE_SEQSCAN TO OFF;
14201420
This parameter can only be set at server start.
14211421
</para>
14221422
<para>
1423-
In <literal>minimal</> level, WAL-logging of some bulk operations, like
1424-
<command>CREATE INDEX</>, <command>CLUSTER</> and <command>COPY</> on
1425-
a table that was created or truncated in the same transaction can be
1426-
safely skipped, which can make those operations much faster (see
1427-
<xref linkend="populate-pitr">). But minimal WAL does not contain
1423+
In <literal>minimal</> level, WAL-logging of some bulk
1424+
operations can be safely skipped, which can make those
1425+
operations much faster (see <xref linkend="populate-pitr">).
1426+
Operations in which this optimization can be applied include:
1427+
<simplelist>
1428+
<item>CREATE TABLE AS</item>
1429+
<item>CREATE INDEX</item>
1430+
<item>CLUSTER</item>
1431+
<item>COPY into tables that were created or truncated in the same
1432+
transaction
1433+
</simplelist>
1434+
But minimal WAL does not contain
14281435
enough information to reconstruct the data from a base backup and the
14291436
WAL logs, so either <literal>archive</> or <literal>hot_standby</>
14301437
level must be used to enable

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp