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

Commit072e607

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

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
@@ -1416,11 +1416,18 @@ SET ENABLE_SEQSCAN TO OFF;
14161416
This parameter can only be set at server start.
14171417
</para>
14181418
<para>
1419-
In <literal>minimal</> level, WAL-logging of some bulk operations, like
1420-
<command>CREATE INDEX</>, <command>CLUSTER</> and <command>COPY</> on
1421-
a table that was created or truncated in the same transaction can be
1422-
safely skipped, which can make those operations much faster (see
1423-
<xref linkend="populate-pitr">). But minimal WAL does not contain
1419+
In <literal>minimal</> level, WAL-logging of some bulk
1420+
operations can be safely skipped, which can make those
1421+
operations much faster (see <xref linkend="populate-pitr">).
1422+
Operations in which this optimization can be applied include:
1423+
<simplelist>
1424+
<item>CREATE TABLE AS</item>
1425+
<item>CREATE INDEX</item>
1426+
<item>CLUSTER</item>
1427+
<item>COPY into tables that were created or truncated in the same
1428+
transaction
1429+
</simplelist>
1430+
But minimal WAL does not contain
14241431
enough information to reconstruct the data from a base backup and the
14251432
WAL logs, so either <literal>archive</> or <literal>hot_standby</>
14261433
level must be used to enable

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp