On Fri, Sep 29, 2017 at 6:22 PM, Hung Phan <hungphan227@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general