Re: What is the relationship between checkpoint and wal

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: 高健 <luckyjackgao(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: What is the relationship between checkpoint and wal
Date: 2013-08-26 09:37:11
Message-ID: CAKoxK+531ddRWbGOpnU3AZW913BGAoxpQ30rrmSWJ0xa8T+CMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 26, 2013 at 4:57 AM, 高健 <luckyjackgao(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian Weimer 2013-08-26 10:54:09 Re: What is the relationship between checkpoint and wal
Previous Message gajendra s v 2013-08-26 07:17:41 Please help me regarding the WITH RECURSIVE query