Re: Is full_page_writes=off safe in conjunction with

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Is full_page_writes=off safe in conjunction with
Дата
Msg-id 1145352435.3865.1.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Is full_page_writes=off safe in conjunction with PITR?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Is full_page_writes=off safe in conjunction with  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: question regarding pg_database.h and DatabaseRelationId
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Question on win32 semaphore simulation