diff options
author | Bruce Momjian <bruce@momjian.us> | 2014-03-24 22:04:44 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2014-03-24 22:04:44 -0400 |
commit | 6c5ced1526b189ed98baa0d195a7078d1afd112e (patch) | |
tree | d5cb523fc8336ac6821ae7ca70a1c96d17a632ee | |
parent | 5db55c6bbca28b8be4d68d2fa0e22465cfe8e755 (diff) | |
download | postgresql-6c5ced1526b189ed98baa0d195a7078d1afd112e.tar.gz postgresql-6c5ced1526b189ed98baa0d195a7078d1afd112e.zip |
doc: list unlogged tables as a non-durable option
-rw-r--r-- | doc/src/sgml/perform.sgml | 17 |
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> |