Re: pgsql: Update warning about synchronous-commit durability, per suggesti - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Update warning about synchronous-commit durability, per suggesti
Date
Msg-id 201101261416.p0QEGHN27291@momjian.us
Whole thread Raw
In response to Re: pgsql: Update warning about synchronous-commit durability, per suggesti  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-committers
Robert Haas wrote:
> On Tue, Jan 25, 2011 at 8:32 PM, Bruce Momjian <bruce@momjian.us> wrote:
> > Update warning about synchronous-commit durability, per suggestion from
> > Robvert Haas.
>
> The revised text is just as silly as the original text.  The point is
> that with fsync turned off, the *entire database* is toast after a
> crash.  You don't need to give any special warning for
> synchronous_commit above and beyond what applies to the whole section.
>  Just delete that part.

I understand now.  Doc patch attached and committed.

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

  + It's impossible for everything to be true. +
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml
index fb55598..0a10457 100644
*** a/doc/src/sgml/perform.sgml
--- b/doc/src/sgml/perform.sgml
*************** SELECT * FROM x, y, a, b, c WHERE someth
*** 1157,1165 ****

       <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 can cause transaction loss after a server crash.
        </para>
       </listitem>
      </itemizedlist>
--- 1157,1165 ----

       <listitem>
        <para>
!        Turn off <xref linkend="guc-synchronous-commit">;  there is no
         need to write the <acronym>WAL</acronym> to disk on every
!        commit.
        </para>
       </listitem>
      </itemizedlist>

pgsql-committers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: pgsql: Make 'on' uppercase in a sql example.
Next
From: Bruce Momjian
Date:
Subject: pgsql: Update sync commit performance documentation to be consistent wi