Re: pgsql: Disable full_page_writes, because turning it

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Disable full_page_writes, because turning it
Date: 2006-04-10 23:15:51
Message-ID: 200604102315.k3ANFpT19105@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers


Added to TODO:

* Re-enable the GUC full_page_writes in 8.2 when reliability issues have
been addressed

---------------------------------------------------------------------------

Tom Lane wrote:
> Log Message:
> -----------
> Disable full_page_writes, because turning it off risks causing crash-recovery
> failures even when the hardware and OS did nothing wrong. Per recent analysis
> of a problem report from Alex Bahdushka.
>
> For the moment I've just diked out the test of the parameter, rather than
> removing the GUC infrastructure and documentation, in case we conclude that
> there's something salvageable there. There seems no chance of it being
> resurrected in the 8.1 branch though.
>
> Tags:
> ----
> REL8_1_STABLE
>
> Modified Files:
> --------------
> pgsql/doc/src/sgml:
> config.sgml (r1.36.2.2 -> r1.36.2.3)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.36.2.2&r2=1.36.2.3)
> pgsql/src/backend/access/transam:
> xlog.c (r1.222.2.2 -> r1.222.2.3)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.222.2.2&r2=1.222.2.3)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-04-11 02:08:20 pgsql: Done, per Tom: < * Allow user-defined functions retuning a
Previous Message Bruce Momjian 2006-04-10 23:15:47 pgsql: Add: * Re-enable the GUC full_page_writes in 8.2 when