MIME-Version: 1.0
References: <CAJCZko+gYNGiixGcqKAhjhLhUZ3QQg2rGs6nH7ZUNwTtjYLfGw@mail.gmail.com>
 <e1bd37c2-9e2c-4914-b8be-bd75b633dfc1@aklaver.com> <CAJCZko+HhLFkiDLDPg3fscUEO4uWyEFT4_e6GBMeywnnwRC-rg@mail.gmail.com>
 <79b7d5dc-3a1d-4ef0-9a3d-055268dc7d09@aklaver.com> <CAJCZkoLZb5ON_T-YecS3-1sQjiGUVLdgKjS93thQyzZKiaWuFQ@mail.gmail.com>
 <3691ad0c-189c-4290-a434-e03cb6301cac@aklaver.com>
In-Reply-To: <3691ad0c-189c-4290-a434-e03cb6301cac@aklaver.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Wed, 22 Jan 2025 01:10:34 +0530
Message-ID: <CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com>
Subject: Re: Records count mismatch with logical replication
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f97ee0062c3c8d26"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ%40mail.gmail.com>
Precedence: bulk

--000000000000f97ee0062c3c8d26
Content-Type: text/plain; charset="UTF-8"

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

--000000000000f97ee0062c3c8d26
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 22 Jan, 2025, 00:22 Adri=
an Klaver, &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@a=
klaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
<br>
On 1/21/25 10:06 AM, Durgamahesh Manne wrote:<br>
<br>
&gt; <br>
&gt; Hi Adrian Klaver<br>
&gt; <br>
&gt; 22,906,216 bytes/10,846 rows=C2=A0 works out to 2112 bytes per row.<br=
>
&gt; <br>
&gt; Is that a reasonable per row estimate?<br>
&gt; <br>
&gt; Yes=C2=A0 sometimes would be vary<br>
<br>
If I am following the lag went from 350GB behind to 22MB.<br>
<br>
Is the issue that the lag has stalled at 22MB?<br>
<br>
&gt; <br>
&gt; Regards,<br>
&gt; Durga Mahesh<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a></blockquote></div></div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Hi Adrian Klaver</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">Is the issue that the lag has stalled at 22MB?</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto">Depends on load of source=
=C2=A0</div><div dir=3D"auto">The lag would be either decrease or increase =
in Kb &#39;s and Mb&#39;s (not Gb&#39;s)</div><div dir=3D"auto">It s not co=
nstant as Data being replicated to target</div><div dir=3D"auto"><br></div>=
<div dir=3D"auto">But records count varies with difference of more than 10 =
thousand=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">How to mi=
tigate this issue in simplest way ?</div><div dir=3D"auto"><br></div><div d=
ir=3D"auto">Regards=C2=A0</div><div dir=3D"auto">Durga Mahesh=C2=A0</div></=
div>

--000000000000f97ee0062c3c8d26--