From 6c5ced1526b189ed98baa0d195a7078d1afd112e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 24 Mar 2014 22:04:44 -0400 Subject: [PATCH] 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 482490ba78..f0ab440cd3 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; + + + Turn off ; there might be no + need to force WAL writes to disk on every + commit. This setting does risk transaction loss (though not data + corruption) in case of a crash of the database. + + + Turn off ; there is no need @@ -1590,12 +1599,12 @@ SELECT * FROM x, y, a, b, c WHERE something AND somethingelse; - Turn off ; there might be no - need to write the WAL to disk on every - commit. This setting does risk transaction loss (though not data - corruption) in case of a crash of the database alone. + Create unlogged + tables to avoid WAL writes, though it + makes the tables non-crash-safe. + -- 2.40.0