public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: 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, 06 Sep 2024 07:02:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com>
References: <CACXtxt_ANB20ZWjFQt=BOtCN50g6MvNvQPokv5TwPSwwXchdkw@mail.gmail.com>
<CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com>
On Fri, 2024-09-06 at 08:33 +0500, Muhammad Usman Khan wrote:
> On Thu, 5 Sept 2024 at 06:04, Karthik Yellapragada <[email protected]> wrote:
> > 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?
> >
>
> 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
These settings won't do anything to mitigate the problem.
All you can do is get more network bandwidth.
Yours,
Laurenz Albe
view thread (10+ messages)
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: Parallelize WAL Sender and WAL receiver
In-Reply-To: <[email protected]>
* 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