On Sat, Sep 21, 2024 at 3:08 PM Ramakrishna m <ram.pgdb@xxxxxxxxx> 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
