postgres.git / summary / log / commit / refs

commit    38de5aad54b3eb37981cacd391fcde82f86d00fb
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Thu Aug 04 16:06:53 2011 +0000
First released in: 9.2.0, 9.0.5, 9.1.0

    In documentaiton, clarify which commands have reduced WAL volume for
    wal_level = minimum.
    
    Backpatch to 9.1 and 9.0.


doc/src/sgml/config.sgml | 17 ++++++++++++----- 1 file 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 [parent: 4af43ee3f165]