Re: What is the relationship between checkpoint and wal

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: What is the relationship between checkpoint and wal
Дата
Msg-id CAKoxK+531ddRWbGOpnU3AZW913BGAoxpQ30rrmSWJ0xa8T+CMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What is the relationship between checkpoint and wal  (高健 <luckyjackgao@gmail.com>)
Ответы Re: What is the relationship between checkpoint and wal  (Florian Weimer <fweimer@redhat.com>)
Список 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 по дате отправления:

Предыдущее
От: gajendra s v
Дата:
Сообщение: Please help me regarding the WITH RECURSIVE query
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: What is the relationship between checkpoint and wal