Re: Keepalive for max_standby_delay

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Josh Berkus <josh@agliodbs.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2010-06-02T17:44:26Z
Lists: pgsql-hackers

Tom Lane wrote:
> I'm still inclined to apply the part of Simon's patch that adds a
> transmit timestamp to each SR send chunk.  That would actually be
> completely unused by the slave given my proposal above, but I think that
> it is an important step to take to future-proof the SR protocol against
> possible changes in the slave-side timing logic.  
>   

+1.

 From a radically different perspective, I had to do something similar 
in the buildfarm years ago to protect us from machines reporting with 
grossly inaccurate timestamps. This was part of the solution. The client 
adds its current timestamp setting just before transmitting the data to 
the server.

cheers

andrew