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

From Heikki Linnakangas
Subject Re: pg_receivexlog --status-interval add fsync feedback
Date
Msg-id 54491ABE.8000707@vmware.com
Whole thread Raw
In response to Re: pg_receivexlog --status-interval add fsync feedback  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: pg_receivexlog --status-interval add fsync feedback
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pg_receivexlog --status-interval add fsync feedback
Next
From: Robert Haas
Date:
Subject: Re: delta relations in AFTER triggers