Re: [GENERAL] pg_rewind copy so much data

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] pg_rewind copy so much data
Дата
Msg-id CAB7nPqS1Lu9Cpf2RkogeTpFMKzcqgGLLK8i+-dtARC47MYr6tA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_rewind copy so much data  (Hung Phan <hungphan227@gmail.com>)
Список pgsql-general
On Fri, Sep 29, 2017 at 6:22 PM, Hung Phan <hungphan227@gmail.com> wrote:
> Thanks for your help. Do you have any more ideas about my case? I cannot
> find any reason for that. If pg_rewind just examines WAL for changed blocks
> from the common checkpoint, why did it copy all data ? As I understand, the
> information in WAL about changes cannot cover all data in the database.

The only thing I have in mind able to create this much amount of data
using this less WAL is a CREATE DATABASE using as template an existing
database. Based on the information you are giving here this is the
best guess I can do.
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Hung Phan
Дата:
Сообщение: Re: [GENERAL] pg_rewind copy so much data
Следующее
От: "Jehan-Guillaume (ioguix) de Rorthais"
Дата:
Сообщение: Re: [GENERAL] Speed of conversion from int to bigint