On Sat, Sep 21, 2024 at 3:08 PM Ramakrishna m <ram.p...@gmail.com> wrote:
> I would greatly appreciate any suggestions you may have to help avoid > logical replication delays, whether through tuning database or operating > system parameters, or any other recommendations > In addition to the things already answered: * What is the use case for logical replication? I assume your local replicas are able to keep up just fine. * Check the nature of the work for problems, e.g. ORM doing unnecessary/redundant updates, maintaining indexes that are not really needed * Looks like your wal_segment_size was boosted to 1GB. What drove that change? * Yes, autovacuum could affect things - make sure log_autovacuum_min_durations is set Cheers, Greg
