Re: pg_receivexlog --status-interval add fsync feedback

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: pg_receivexlog --status-interval add fsync feedback
Дата
Msg-id 54491ABE.8000707@vmware.com
обсуждение исходный текст
Ответ на Re: pg_receivexlog --status-interval add fsync feedback  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: pg_receivexlog --status-interval add fsync feedback
Список pgsql-hackers
On 10/23/2014 06:01 PM, Simon Riggs wrote:
> On 23 October 2014 15:39, Fujii Masao <masao.fujii@gmail.com> wrote:
>
>> Sorry, I'm going around in the circle. But I'd like to say again, I don't think
>> this is good idea. It prevents asynchronous pg_receivexlog from fsyncing
>> WAL data and sending feedbacks more frequently at all. They are useful,
>> for example, when we want to monitor the write location of asynchronous
>> pg_receivexlog in almost realtime. But if we adopt the idea, since feedback
>> cannot be sent soon in async mode, pg_stat_replication always returns
>> the not-up-to-date location.
>
> Why not send a message every 10 seconds when its not sync rep?

Or even after every write(). It's a tiny amount of network traffic anyway.

- Heikki




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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: pg_receivexlog --status-interval add fsync feedback
Следующее
От: Robert Haas
Дата:
Сообщение: Re: delta relations in AFTER triggers