Re: Logical Replication of sequences

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Euler Taveira <euler(at)eulerto(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Subject: Re: Logical Replication of sequences
Date: 2025-05-20 05:43:04
Message-ID: CAHut+PstucunJLQn8C=bewmYdoSQStBcEJgG2bkZJUZnTowhFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Test-scenario:
> --Created 250 sequences on both pub and sub.
> --There were 10 sequences mismatched.
> --Sequence replication worked as expected. Logs look better now:
>
> LOG: Logical replication sequence synchronization for subscription
> "sub1" - total unsynchronized: 250; batch #1 = 100 attempted, 97
> succeeded, 3 mismatched
> LOG: Logical replication sequence synchronization for subscription
> "sub1" - total unsynchronized: 250; batch #2 = 100 attempted, 95
> succeeded, 5 mismatched
> LOG: Logical replication sequence synchronization for subscription
> "sub1" - total unsynchronized: 250; batch #3 = 50 attempted, 48
> succeeded, 2 mismatched
>

When there are many batches required, it seems a bit strange to repeat
the same "total unsynchronized" over and over.

Would it be better to show the total number once, and thereafter show
the number of sequences remaining to be processed as they tick down?

e.g.
LOG: Logical replication sequence synchronization for subscription
"sub1" - total unsynchronized = 250
LOG: Logical replication sequence synchronization for subscription
"sub1" - batch #1 = 100 attempted, 97 succeeded, 3 mismatched, 150
remaining
LOG: Logical replication sequence synchronization for subscription
"sub1" - batch #2 = 100 attempted, 95 succeeded, 5 mismatched, 50
remaining
LOG: Logical replication sequence synchronization for subscription
"sub1" - batch #3 = 50 attempted, 48 succeeded, 2 mismatched, 0
remaining

======
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2025-05-20 05:50:07 Re: wrong query results on bf leafhopper
Previous Message shveta malik 2025-05-20 05:40:14 Re: Conflict detection for update_deleted in logical replication