Re: [PATCHES] Full page writes improvement - Mailing list pgsql-hackers

From Koichi Suzuki
Subject Re: [PATCHES] Full page writes improvement
Date
Msg-id 45C2884A.50607@oss.ntt.co.jp
Whole thread Raw
In response to Re: [PATCHES] Full page writes improvement  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] Full page writes improvement
List pgsql-hackers
Tom Lane wrote:
> Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp> writes:
>> Here's an idea and a patch for full page writes improvement.
>
>> Idea:
>> (1) keep full page writes for ordinary WAL, make them available during
>> the crash recovery, -> recovery from inconsistent pages which can be
>> made at the crash,
>> (2) Remove them from the archive log except for those written during
>> online backup (between pg_start_backup and pg_stop_backup) -> small size
>> archive log.
>
> Doesn't this break crash recovery on PITR slaves?

Compressed archive log contains the same data as full_page_writes off
case.   So the influence to PITR slaves is the same as full_page_writes off.

                        K.Suzuki

>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


--
Koichi Suzuki

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: writing new regexp functions
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Full page writes improvement