Re: WALWriter active during recovery

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: WALWriter active during recovery
Дата
Msg-id CAHGQGwFfbzdNrNzQdpH8N3yHSd1XCpd7ybxQ0q0yOwk2v=se8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WALWriter active during recovery  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: WALWriter active during recovery  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On Thu, Dec 18, 2014 at 6:43 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Tue, Dec 16, 2014 at 3:51 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Currently, WALReceiver writes and fsyncs data it receives. Clearly,
>> while we are waiting for an fsync we aren't doing any other useful
>> work.
>>
>> Following patch starts WALWriter during recovery and makes it
>> responsible for fsyncing data, allowing WALReceiver to progress other
>> useful actions.

With the patch, replication didn't work fine in my machine. I started
the standby server after removing all the WAL files from the standby.
ISTM that the patch doesn't handle that case. That is, in that case,
the standby tries to start up walreceiver and replication to retrieve
the REDO-starting checkpoint record *before* starting up walwriter
(IOW, before reaching the consistent point). Then since walreceiver works
without walwriter, no received WAL data cannot be fsync'd in the standby.
So replication cannot advance furthermore. I think that walwriter needs
to start before walreceiver starts.

I just marked this patch as Waiting on Author.

Regards,

-- 
Fujii Masao



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: TABLESAMPLE patch
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Table-level log_autovacuum_min_duration