Search Postgresql Archives

Re: Records count mismatch with logical replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

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 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux