public inbox for [email protected]  

help / color / mirror / Atom feed
From: Durgamahesh Manne <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Records count mismatch with logical replication
Date: Wed, 22 Jan 2025 01:10:34 +0530
Message-ID: <CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJCZko+gYNGiixGcqKAhjhLhUZ3QQg2rGs6nH7ZUNwTtjYLfGw@mail.gmail.com>
	<[email protected]>
	<CAJCZko+HhLFkiDLDPg3fscUEO4uWyEFT4_e6GBMeywnnwRC-rg@mail.gmail.com>
	<[email protected]>
	<CAJCZkoLZb5ON_T-YecS3-1sQjiGUVLdgKjS93thQyzZKiaWuFQ@mail.gmail.com>
	<[email protected]>

On Wed, 22 Jan, 2025, 00:22 Adrian Klaver, <[email protected]>
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
> [email protected]


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


view thread (13+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Records count mismatch with logical replication
  In-Reply-To: <CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox