Re: Records count mismatch with logical replication - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: Records count mismatch with logical replication
Date
Msg-id CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com
Whole thread Raw
In response to Re: Records count mismatch with logical replication  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Records count mismatch with logical replication
List pgsql-general


On Wed, 22 Jan, 2025, 00:22 Adrian Klaver, <adrian.klaver@aklaver.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.klaver@aklaver.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 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Records count mismatch with logical replication
Next
From: Adrian Klaver
Date:
Subject: Re: Records count mismatch with logical replication