aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2014-03-24 22:04:44 -0400
committerBruce Momjian <bruce@momjian.us>2014-03-24 22:04:44 -0400
commit6c5ced1526b189ed98baa0d195a7078d1afd112e (patch)
treed5cb523fc8336ac6821ae7ca70a1c96d17a632ee
parent5db55c6bbca28b8be4d68d2fa0e22465cfe8e755 (diff)
downloadpostgresql-6c5ced1526b189ed98baa0d195a7078d1afd112e.tar.gz
postgresql-6c5ced1526b189ed98baa0d195a7078d1afd112e.zip
doc: list unlogged tables as a non-durable option
-rw-r--r--doc/src/sgml/perform.sgml17
1 files 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
@@ -1574,6 +1574,15 @@ 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 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
to guard against partial page writes.
</para>
@@ -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>