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 <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
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>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
