Re: pg_receivexlog --status-interval add fsync feedback - Mailing list pgsql-hackers

From
Subject Re: pg_receivexlog --status-interval add fsync feedback
Date
Msg-id A9C510524E235E44AE909CD4027AE196BF7D6FB25F@MBX-MSG-SV03.msg.nttdata.co.jp
Whole thread Raw
In response to Re: pg_receivexlog --status-interval add fsync feedback  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: pg_receivexlog --status-interval add fsync feedback
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: detect custom-format dumps in psql and emit a useful error
Next
From: Amit Kapila
Date:
Subject: Re: Wait free LW_SHARED acquisition - v0.2