public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Ramakrishna m <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Logical Replication Delay
Date: Wed, 25 Sep 2024 10:42:07 -0400
Message-ID: <CAKAnmmLmvuo=TORx=hDw2y5fFOUc0sHb88O+6Z-Cs=oVtN9W4A@mail.gmail.com> (raw)
In-Reply-To: <CAG-eXHKr5pFzCKNqVhjQAUM0oxxCe8YUfjoLT8WmZx54Sk48kg@mail.gmail.com>
References: <CAG-eXHKr5pFzCKNqVhjQAUM0oxxCe8YUfjoLT8WmZx54Sk48kg@mail.gmail.com>
On Sat, Sep 21, 2024 at 3:08 PM Ramakrishna m <[email protected]> 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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Logical Replication Delay
In-Reply-To: <CAKAnmmLmvuo=TORx=hDw2y5fFOUc0sHb88O+6Z-Cs=oVtN9W4A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox