Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7951=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WSGk2-0008DM-6C
 for pgsql-docs@arkaria.postgresql.org; Tue, 25 Mar 2014 02:05:26 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7951=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WSGk1-0000uN-M2
 for pgsql-docs@arkaria.postgresql.org; Tue, 25 Mar 2014 02:05:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WSGk1-0000uH-3Q
 for pgsql-docs@postgresql.org; Tue, 25 Mar 2014 02:05:25 +0000
Received: from momjian.us ([72.94.173.45])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WSGjy-0001q0-5T
 for pgsql-docs@postgresql.org; Tue, 25 Mar 2014 02:05:24 +0000
Received: from bruce by momjian.us with local (Exim 4.72)
 (envelope-from <bruce@momjian.us>) id 1WSGjx-00010B-9C
 for pgsql-docs@postgresql.org; Mon, 24 Mar 2014 22:05:21 -0400
Date: Mon, 24 Mar 2014 22:05:21 -0400
From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: mention of unlogged tables
Message-ID: <20140325020521.GH15836@momjian.us>
References: <20131220185800.GC1701@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="g7w8+K/95kPelPD2"
Content-Disposition: inline
In-Reply-To: <20131220185800.GC1701@momjian.us>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


--g7w8+K/95kPelPD2
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Fri, Dec 20, 2013 at 01:58:00PM -0500, Bruce Momjian wrote:
> Is there a reason we don't mention unlogged tables in our Non-Durable
> Settings docs section?
> 
> 	http://www.postgresql.org/docs/devel/static/non-durability.html

I have applied the attached patch to mention unlogged tables in our
non-durable doc section;  I also reordered the items.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

--g7w8+K/95kPelPD2
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="unlogged.diff"

diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml
new file mode 100644
index 482490b..f0ab440
*** a/doc/src/sgml/perform.sgml
--- b/doc/src/sgml/perform.sgml
*************** SELECT * FROM x, y, a, b, c WHERE someth
*** 1574,1579 ****
--- 1574,1588 ----
  
       <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>
*************** SELECT * FROM x, y, a, b, c WHERE someth
*** 1590,1601 ****
  
       <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.
        </para>
       </listitem>
      </itemizedlist>
     </para>
    </sect1>
--- 1599,1610 ----
  
       <listitem>
        <para>
!        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>

--g7w8+K/95kPelPD2
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--g7w8+K/95kPelPD2--