Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WALfiles

Поиск
Список
Период
Сортировка
От chenhj
Тема Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WALfiles
Дата
Msg-id 76e330e3.2.15e95ef4236.Coremail.chjischj@163.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WAL files  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WALfiles  (chenhj <chjischj@163.com>)
Список pgsql-hackers

At 2017-09-17 08:33:33, "Michael Paquier" <michael.paquier@gmail.com> wrote: >On Sun, Sep 17, 2017 at 3:19 AM, Alexander Korotkov ><a.korotkov@postgrespro.ru> wrote: >> Hi! >> >> On Sat, Sep 16, 2017 at 5:56 PM, chenhj <chjischj@163.com> wrote: >>> >>> This patch optimizes the above mentioned issues, as follows: >>> 1. In the target data directory, do not delete the WAL files before the >>> divergence. >>> 2. When copying files from the source server, do not copy the WAL files >>> before the divergence and the WAL files after the current WAL insert >>> localtion. >> >> >> Looks like cool optimization for me. Please, add this patch to the next >> commitfest. > >Agreed. > >> Do you think this patch should modify pg_rewind tap tests too? It would be >> nice to make WAL files fetching more covered by tap tests. In particular, >> new tests may generate more WAL files and make sure that pg_rewind fetches >> only required files among them. > >This looks mandatory to me. Using pg_switch_wal() and a minimum amount >of WAL generated you could just make the set of WAL segments skipped >minimal data. > >I have not checked in details, but I think that the positions where >you are applying the filters are using the right approach. > >! !(strncmp(path, "pg_wal", 6) == 0 && IsXLogFileName(path + 7) && >Please use XLOGDIR here. >-- >Michael >
Thanks, I will use XLOGDIR and add TAP tests later.

--
Chen Huajun

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] [PATCH] Add citext_pattern_ops to citext contrib module
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [HACKERS] GnuTLS support