public inbox for [email protected]
help / color / mirror / Atom feedFrom: Muhammad Usman Khan <[email protected]>
To: Karthik Yellapragada <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Parallelize WAL Sender and WAL receiver
Date: Fri, 6 Sep 2024 08:33:23 +0500
Message-ID: <CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com> (raw)
In-Reply-To: <CACXtxt_ANB20ZWjFQt=BOtCN50g6MvNvQPokv5TwPSwwXchdkw@mail.gmail.com>
References: <CACXtxt_ANB20ZWjFQt=BOtCN50g6MvNvQPokv5TwPSwwXchdkw@mail.gmail.com>
Hi,
You can try to set the following parameters in the conf file which may help
to overcome this problem.
wal_sender_timeout = 60s
wal_receiver_status_interval = 1s
Ensure you have sufficient WAL senders like max_wal_senders = 10
max_wal_size = 2GB
min_wal_size = 80MB
wal_buffers = 16MB
wal_level = replica
On Thu, 5 Sept 2024 at 06:04, Karthik Yellapragada <
[email protected]> wrote:
> Hello all,
>
> I frequently face the problem of wals generated faster than the wals
> transferred and applied.
>
> Is there a way to speed up the process? So I don’t accumulate a lot of
> WALs at the primary?
>
> Regards,
> Karthik.
> --
> Thanks & Regards
> Karthik Yellapragada
> +1 860 830 5235
>
view thread (10+ messages) latest in thread
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]
Subject: Re: Parallelize WAL Sender and WAL receiver
In-Reply-To: <CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@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