Re: Regarding huge logical slot lag between source and target

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

ALTER SUBSCRIPTION sub SET (streaming = parallel);

Also, set the following parameters to generous values (as your hardware
allows):

On the publisher:

logical_decoding_work_mem

On the subscriber:

max_logical_replication_workers
max_worker_processes
max_parallel_apply_workers_per_subscription
max_sync_workers_per_subscription

Note the dependencies: max_worker_processes must accommodate for all the
worker processes.

Yours,
Laurenz Albe