postgres.git / summary / log / commit / refs

commit    6c5ced1526b189ed98baa0d195a7078d1afd112e
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Mar 25 02:04:44 2014 +0000
First released in: 9.4.0

    doc:  list unlogged tables as a non-durable option


 doc/src/sgml/perform.sgml | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml
index 482490ba78c..f0ab440cd38 100644
--- a/doc/src/sgml/perform.sgml
+++ b/doc/src/sgml/perform.sgml
@@ -1572,6 +1572,15 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse;
       </para>
      </listitem>
 
+     <listitem>
+      <para>
+       Turn off <xref linkend="guc-synchronous-commit">;  there might be no
+       need to force <acronym>WAL</acronym> writes to disk on every
+       commit.  This setting does risk transaction loss (though not data
+       corruption) in case of a crash of the <emphasis>database</>.
+      </para>
+     </listitem>
+
      <listitem>
       <para>
        Turn off <xref linkend="guc-full-page-writes">;  there is no need
@@ -1590,12 +1599,12 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse;
 
      <listitem>
       <para>
-       Turn off <xref linkend="guc-synchronous-commit">;  there might be no
-       need to write the <acronym>WAL</acronym> to disk on every
-       commit.  This setting does risk transaction loss (though not data
-       corruption) in case of a crash of the <emphasis>database</> alone.
+       Create <link linkend="SQL-CREATETABLE-UNLOGGED">unlogged
+       tables</link> to avoid <acronym>WAL</acronym> writes, though it
+       makes the tables non-crash-safe.
       </para>
      </listitem>
+
     </itemizedlist>
    </para>
   </sect1>


[parent: 5db55c6bbca2]