Re: Records count mismatch with logical replication

On Wed, 22 Jan, 2025, 00:22 Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

>
>
> On 1/21/25 10:06 AM, Durgamahesh Manne wrote:
>
> >
> > Hi Adrian Klaver
> >
> > 22,906,216 bytes/10,846 rows works out to 2112 bytes per row.
> >
> > Is that a reasonable per row estimate?
> >
> > Yes sometimes would be vary
>
> If I am following the lag went from 350GB behind to 22MB.
>
> Is the issue that the lag has stalled at 22MB?
>
> >
> > Regards,
> > Durga Mahesh
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com

Hi Adrian Klaver

Is the issue that the lag has stalled at 22MB?

Depends on load of source
The lag would be either decrease or increase in Kb 's and Mb's (not Gb's)
It s not constant as Data being replicated to target

But records count varies with difference of more than 10 thousand

How to mitigate this issue in simplest way ?

Regards
Durga Mahesh