Re: Time delayed LR (WAS Re: logical replication restrictions)

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Time delayed LR (WAS Re: logical replication restrictions)
Дата
Msg-id CAA4eK1+uEVsKTKuPGaBPfGaRBpjP3W78Cj9F4UjQnu8qwmqwEg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Time delayed LR (WAS Re: logical replication restrictions)  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Ответы Re: Time delayed LR (WAS Re: logical replication restrictions)  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
On Wed, Jan 25, 2023 at 11:57 AM Kyotaro Horiguchi
<horikyota.ntt@gmail.com> wrote:
>
> At Tue, 24 Jan 2023 12:19:04 +0000, "Takamichi Osumi (Fujitsu)" <osumi.takamichi@fujitsu.com> wrote in
> > Attached the patch v20 that has incorporated all comments so far.
>
...
>
>
> +          in which case no additional wait is necessary. If the system clocks
> +          on publisher and subscriber are not synchronized, this may lead to
> +          apply changes earlier than expected, but this is not a major issue
> +          because this parameter is typically much larger than the time
> +          deviations between servers. Note that if this parameter is set to a
>
> This doesn't seem to fit our documentation. It is not our business
> whether a certain amount deviation is critical or not. How about
> somethig like the following?
>

But we have a similar description for 'recovery_min_apply_delay' [1].
See "...If the system clocks on primary and standby are not
synchronized, this may lead to recovery applying records earlier than
expected; but that is not a major issue because useful settings of
this parameter are much larger than typical time deviations between
servers."

[1] - https://www.postgresql.org/docs/devel/runtime-config-replication.html

-- 
With Regards,
Amit Kapila.



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Time delayed LR (WAS Re: logical replication restrictions)
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: wake up logical workers after ALTER SUBSCRIPTION