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

From Hannu Krosing
Subject Re: Is full_page_writes=off safe in conjunction with
Date
Msg-id 1145352435.3865.1.camel@localhost.localdomain
Whole thread Raw
In response to Re: Is full_page_writes=off safe in conjunction with PITR?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Is full_page_writes=off safe in conjunction with  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Ü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.

Do you have an estimate, how big the impact is ?

-----------
Hannu




pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: question regarding pg_database.h and DatabaseRelationId
Next
From: "Magnus Hagander"
Date:
Subject: Re: Question on win32 semaphore simulation