Re: pg_receivexlog --status-interval add fsync feedback

Поиск
Список
Период
Сортировка
От
Тема Re: pg_receivexlog --status-interval add fsync feedback
Дата
Msg-id A9C510524E235E44AE909CD4027AE196BF7D6FB25F@MBX-MSG-SV03.msg.nttdata.co.jp
обсуждение исходный текст
Ответ на Re: pg_receivexlog --status-interval add fsync feedback  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: pg_receivexlog --status-interval add fsync feedback
Список pgsql-hackers
> >> 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.

I understand that send feedback message frequently will keep pg_stat_replication up-to-date state.

Are there really no needs who wants to fsync even in async mode ?
I think the people who dislike Data lost will like that idea.
Thought?

Nevertheless in sync or async, returning feedback and executing fsync() same as like walreceiver is such a problem?

--
Furuya Osamu


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: detect custom-format dumps in psql and emit a useful error
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Wait free LW_SHARED acquisition - v0.2