On Sun, 2026-10-18 at 23:11 +0530, Durgamahesh Manne wrote: > On Sun, 18 Oct, 2026, 22:52 Laurenz Albe, <[email protected]> wrote: > > On Sun, 2026-10-18 at 19:49 +0530, Durgamahesh Manne wrote: > > > Logical slot lag 330GB on source grows faster during the huge > > > modifications but it should be minimized which is not happened when load > > > goes down. > > > > > > What is the action need to take for minimizing the lag to normal state. > > > Source version 16 > > > Target version 16 > > > Sufficient resources allocated and tuned replication related parameters > > > > [I suggested "streaming = parallel" and increasing some parameters} > > I already set those params with required values to make server running > smoothly > > Alter subscription also done with binary and streaming options > > Finally I could not find root cause what has caused to increase of that much > lag. > > No long running queries at source > No blocking at target > Generally what might be reason to huge lag in terms of hundreds which can't > go down.
Perhaps DDL statements on the publisher. Yours, Laurenz Albe
