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
