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

Commit38de5aa

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

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
@@ -1451,11 +1451,18 @@ SET ENABLE_SEQSCAN TO OFF;
14511451
This parameter can only be set at server start.
14521452
</para>
14531453
<para>
1454-
In <literal>minimal</> level, WAL-logging of some bulk operations, like
1455-
<command>CREATE INDEX</>, <command>CLUSTER</> and <command>COPY</> on
1456-
a table that was created or truncated in the same transaction can be
1457-
safely skipped, which can make those operations much faster (see
1458-
<xref linkend="populate-pitr">). But minimal WAL does not contain
1454+
In <literal>minimal</> level, WAL-logging of some bulk
1455+
operations can be safely skipped, which can make those
1456+
operations much faster (see <xref linkend="populate-pitr">).
1457+
Operations in which this optimization can be applied include:
1458+
<simplelist>
1459+
<item>CREATE TABLE AS</item>
1460+
<item>CREATE INDEX</item>
1461+
<item>CLUSTER</item>
1462+
<item>COPY into tables that were created or truncated in the same
1463+
transaction
1464+
</simplelist>
1465+
But minimal WAL does not contain
14591466
enough information to reconstruct the data from a base backup and the
14601467
WAL logs, so either <literal>archive</> or <literal>hot_standby</>
14611468
level must be used to enable

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp