public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fujii Masao <[email protected]>
To: Jakub Wartak <[email protected]>
To: Amit Kapila <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: doc: Mention clock synchronization recommendation for hot_standby_feedback
Date: Mon, 3 Mar 2025 18:48:41 +0900
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKZiRmyEBkR5tfwrzXaoC6D29Gp6g_fD6Bd_k58DjZV1=rbKdQ@mail.gmail.com>
References: <CAKZiRmwBcALLrDgCyEhHP1enUxtPMjyNM_d1A2Lng3_6Rf4Qfw@mail.gmail.com>
	<CAA4eK1JG1R4c7DDEdr7QAiQ1sFjb-EkQmp1H=dSKguoKX7PZDg@mail.gmail.com>
	<CAKZiRmyC8r5Yc7dhUrxMmYF4+_QitFNDf4fwGp6p1ER+3UydUw@mail.gmail.com>
	<CAA4eK1+sM11DVgtfjTyLA4dBox109z94iQe0wPJWNtZm4MqXCg@mail.gmail.com>
	<CAKZiRmyEBkR5tfwrzXaoC6D29Gp6g_fD6Bd_k58DjZV1=rbKdQ@mail.gmail.com>



On 2025/03/03 16:35, Jakub Wartak wrote:
> Hi Amit,
> 
> On Mon, Mar 3, 2025 at 6:26 AM Amit Kapila <[email protected]> wrote:
> [..]
> 
> OK, sure.
> 
>> How about something like: "Note that if the clock on standby is moved
>> ahead or backward, the feedback message may not be sent at the
>> required interval. This can lead to prolonged risk of not removing
>> dead rows on primary for extended periods as the feedback mechanism is
>> based on timestamp."
> 
> Sure thing. I've just added '(..) In the extreme cases this can..' as
> it is pretty rare to hit it. Patch attached.

When the clock moves forward or backward, couldn't it affect
not only the standby but also the primary? I’m wondering
because TimestampDifferenceExceeds() seems to be used
in several places in addition to hot standby feedback.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

view thread (16+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: doc: Mention clock synchronization recommendation for hot_standby_feedback
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox