public inbox for [email protected]  

help / color / mirror / Atom feed

From: Amit Kapila <[email protected]>
To: Dilip Kumar <[email protected]>
Cc: Ajin Cherian <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: [PATCH] Support automatic sequence replication
Date: Fri, 20 Feb 2026 10:48:28 +0530
Message-ID: <CAA4eK1+Tn+T3qRts6hSqko7oyNiWS1U_mDkXw6+zGhAAde3CZA@mail.gmail.com> (raw)
In-Reply-To: <CAFiTN-tFanrK2S=ALc++vmOnS07mumSLA91aaYejBHi7X8+rUg@mail.gmail.com>
References: <CAFPTHDZXX9WQ_X1ZfEvS248T+pKuk6SmCnXcvgPM059N1xPUfA@mail.gmail.com>
	<CAFiTN-tFanrK2S=ALc++vmOnS07mumSLA91aaYejBHi7X8+rUg@mail.gmail.com>

On Fri, Feb 20, 2026 at 10:11 AM Dilip Kumar <[email protected]> wrote:
>
> On Tue, Feb 3, 2026 at 9:18 AM Ajin Cherian <[email protected]> wrote:
> >
> > Hello hackers,
> >
> > I'd like to propose an improvement to the sequence replication feature
> > that was committed in [1].
> >
> > The current implementation synchronizes sequences during initial
> > subscription setup, but the sequence sync worker exits after this
> > initial sync. This means that as sequences advance on the publisher,
> > they drift from the subscriber values over time. Users must manually
> > run ALTER SUBSCRIPTION ... REFRESH SEQUENCES to resynchronize, which
> > requires monitoring and intervention.
>
> Thanks, Ajin, for the proposal. I am trying to think: what is the use
> case for automatically updating the sequence values? IIUC, the only
> use case for the sequence sync worker was when using logical
> replication for an upgrade; after the upgrade, you should have
> up-to-date values for the sequences. By adding an automatic update,
> are you targeting any new use case?
>
> If we are still targeting the same use case, I’d like to understand
> how updating the value at specific intervals will improve the user
> experience.
>

Even for an upgrade, to avoid large downtime, it would be better if
the subscriber has the latest values of sequences, so that during the
upgrade of the publisher, the subscriber can receive all client
requests. It is possible with the REFRESH SEQUENCES command as well
but in the worst case (when there are large number of sequences), it
can take much longer time.

-- 
With Regards,
Amit Kapila.

view thread (5+ 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], [email protected]
  Subject: Re: [PATCH] Support automatic sequence replication
  In-Reply-To: <CAA4eK1+Tn+T3qRts6hSqko7oyNiWS1U_mDkXw6+zGhAAde3CZA@mail.gmail.com>

* 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