Re: Skipping logical replication transactions on subscriber side

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Skipping logical replication transactions on subscriber side
Дата
Msg-id CAKFQuwbzMsUHjx2eLLDSFyiTqnN4q8b_Ar6rME4SM0M7L3wd9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Skipping logical replication transactions on subscriber side  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers


On Monday, January 24, 2022, Amit Kapila <amit.kapila16@gmail.com> wrote:
On Mon, Jan 24, 2022 at 1:30 PM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> That said, at present my two dislikes:
>
> 1) ALTER SYSTEM SKIP accepts any xid value (I need to consider further the timing of when this resets to zero)
>

I think this is required for future extension of this feature wherein
I think there could be multiple such xids say when we support parallel
apply workers. I think if we get a good way to do it even after the
first version like by making a xid an optional parameter.


Extending the behavior is doable, and maybe we end up without this limitation in the future, so be it.  But I’m having a hard time imagining a scenario where the xid is not already known to the system, and the user, and wants to be in effect for a very short window.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: makefiles writing to $@ should first write to $@.new
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: automatically generating node support functions