Re: Is full_page_writes=off safe in conjunction with

Ü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