Re: Parallelize WAL Sender and WAL receiver - Mailing list pgsql-admin

On Fri, 2024-09-06 at 08:33 +0500, Muhammad Usman Khan wrote:
> On Thu, 5 Sept 2024 at 06:04, Karthik Yellapragada <karthik.yellapragada@gmail.com> 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