diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-08-04 12:06:53 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-08-04 12:06:53 -0400 |
| commit | 38de5aad54b3eb37981cacd391fcde82f86d00fb (patch) | |
| tree | 8ccb7bedc8f68008b6fc5d8df0f98528d563b4c4 /doc/src | |
| parent | 4af43ee3f165c8e4b332a7e680a44f4b7ba2d3c1 (diff) | |
| download | postgresql-38de5aad54b3eb37981cacd391fcde82f86d00fb.tar.gz postgresql-38de5aad54b3eb37981cacd391fcde82f86d00fb.zip | |
In documentaiton, clarify which commands have reduced WAL volume for
wal_level = minimum.
Backpatch to 9.1 and 9.0.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 4fadca955c3..b774e2a3328 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1451,11 +1451,18 @@ SET ENABLE_SEQSCAN TO OFF; This parameter can only be set at server start. </para> <para> - In <literal>minimal</> level, WAL-logging of some bulk operations, like - <command>CREATE INDEX</>, <command>CLUSTER</> and <command>COPY</> on - a table that was created or truncated in the same transaction can be - safely skipped, which can make those operations much faster (see - <xref linkend="populate-pitr">). But minimal WAL does not contain + In <literal>minimal</> level, WAL-logging of some bulk + operations can be safely skipped, which can make those + operations much faster (see <xref linkend="populate-pitr">). + Operations in which this optimization can be applied include: + <simplelist> + <item>CREATE TABLE AS</item> + <item>CREATE INDEX</item> + <item>CLUSTER</item> + <item>COPY into tables that were created or truncated in the same + transaction + </simplelist> + But minimal WAL does not contain enough information to reconstruct the data from a base backup and the WAL logs, so either <literal>archive</> or <literal>hot_standby</> level must be used to enable |