Re: What is the relationship between checkpoint and wal - Mailing list pgsql-general

From Luca Ferrari
Subject Re: What is the relationship between checkpoint and wal
Date
Msg-id CAKoxK+531ddRWbGOpnU3AZW913BGAoxpQ30rrmSWJ0xa8T+CMg@mail.gmail.com
Whole thread Raw
In response to Re: What is the relationship between checkpoint and wal  (高健 <luckyjackgao@gmail.com>)
Responses Re: What is the relationship between checkpoint and wal  (Florian Weimer <fweimer@redhat.com>)
List pgsql-general
On Mon, Aug 26, 2013 at 4:57 AM, 高健 <luckyjackgao@gmail.com> wrote:
> But why "writes the entire content of each disk page to WAL "?
>

The documentation states that: "The row-level change data normally
stored in WAL will not be enough to completely restore such a page
during post-crash recovery.". I guess that a mixed page (i.e., a page
that contains old and new data) cannot be safely recovered with
deltas, so you need to have a "clean" page image to which start
recovery.

Someone with more internal knowledge can comment on this.

Luca


pgsql-general by date:

Previous
From: gajendra s v
Date:
Subject: Please help me regarding the WITH RECURSIVE query
Next
From: Florian Weimer
Date:
Subject: Re: What is the relationship between checkpoint and wal