Re: Logical Replication of sequences

On Sat, 25 Oct 2025 at 12:27, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Fri, Oct 24, 2025 at 8:52 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> >
> > On Thu, 23 Oct 2025 at 16:47, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > >
> > > On Thu, Oct 23, 2025 at 11:45 AM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> > > >
> > > > The attached patch has the changes for the same.
> > > >
> > >
> > > I have pushed 0001 and the following are comments on 0002.
> > >
> > > 1.
> > > @@ -1414,6 +1414,7 @@ CREATE VIEW pg_stat_subscription_stats AS
> > > ss.subid,
> > > s.subname,
> > > ss.apply_error_count,
> > > + ss.sequence_sync_error_count,
> > > ss.sync_error_count,
> > >
> > > The new parameter name is noticeably longer than other columns. Can we
> > > name it as ss.seq_sync_error_count. We may also want to reconsider
> > > changing existing column sync_error_count to tbl_sync_error_count. Can
> > > we extract this in a separate stats patch?
> >
> > Modified and extracted a separate patch for tbl_sync_error_count
> >
>
> Hmm, I didn't want to make the stats related changes before the main
> patch. I suggested to extract seq_sync_error_count from the main patch
> and keep it after the main patch.

Made this change.

> Along with the seq_sync_error_count
> stats, we can discuss whether to change existing parameter to
> tbl_sync_error_count.

I have removed the tbl_sync_error_count changes for now, I will add it
if required when we get to that patch.

This version also addresses Chao's comments on 0002 which he posted at [1].
The attached patch has the changes for the same.

[1] - https://www.postgresql.org/message-id/BABE39BA-6893-4D65-8432-5523960FFC2B%40gmail.com

Regards,
Vignesh