Re: Logical Replication of sequences - Mailing list pgsql-hackers

From Peter Smith
Subject Re: Logical Replication of sequences
Date
Msg-id CAHut+PstucunJLQn8C=bewmYdoSQStBcEJgG2bkZJUZnTowhFQ@mail.gmail.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (Peter Smith <smithpb2250@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Conflict detection for update_deleted in logical replication
Next
From: David Rowley
Date:
Subject: Re: wrong query results on bf leafhopper