Re: Records count mismatch with logical replication
| От | Durgamahesh Manne |
|---|---|
| Тема | Re: Records count mismatch with logical replication |
| Дата | |
| Msg-id | CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Records count mismatch with logical replication (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Records count mismatch with logical replication
|
| Список | 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 по дате отправления: