Re: Is full_page_writes=off safe in conjunction with - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Is full_page_writes=off safe in conjunction with
Date
Msg-id 1145381183.5878.15.camel@localhost.localdomain
Whole thread Raw
In response to Re: Is full_page_writes=off safe in conjunction with  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Tue, 2006-04-18 at 08:44 -0400, Bruce Momjian wrote:
> Hannu Krosing wrote:
> > ?hel kenal p?eval, E, 2006-04-17 kell 17:14, kirjutas Bruce Momjian:
> > > Jim C. Nasby wrote:
> > > > Are you going to back-patch this? If I understand correctly current
> > > > behavior could mean people using PITR may have invalid backups. In the
> > > > meantime, perhaps we should send an email to -annouce recommending that
> > > > folks issue a CHEKCPOINT; after pg_start_backup and before initiating
> > > > the filesystem copy.
> > > 
> > > We are disabling full_page_writes for 8.1.4, so they should be fine.
> > 
> > Except that people currently using full_page_writes=off on 8.1 may see a sudden 
> > drop in performance after upgrading.
> 
> Yea, but if it can cause corruption, we have no choice.  It will be
> mentioned in the release notes.

Perhaps would should make it more visible then that? The postgresql.org
website has said, PostgreSQL 8.1 released since it was... perhaps it is
time to make it say:

PostgreSQL 8.1.4 Critical Patch released?

Joshua D. Drake


> 
> > Do you have an estimate, how big the impact is ?
> 
> Nope.
> 
-- 
           === The PostgreSQL Company: Command Prompt, Inc. ===     Sales/Support: +1.503.667.4564 || 24x7/Emergency:
+1.800.492.2240    Providing the most comprehensive  PostgreSQL solutions since 1997
http://www.commandprompt.com/






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Corrupt data pages...
Next
From: Mark Wong
Date:
Subject: Re: Summer of Code