Re: Parallelize WAL Sender and WAL receiver

From: Muhammad Usman Khan <usman(dot)k(at)bitnine(dot)net>
To: Karthik Yellapragada <karthik(dot)yellapragada(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Parallelize WAL Sender and WAL receiver
Date: 2024-09-06 03:33:23
Message-ID: CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <
karthik(dot)yellapragada(at)gmail(dot)com> 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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Usman Khan 2024-09-06 03:44:20 Re: Incremental load from SQL server DB to postgressql
Previous Message Sam Stearns 2024-09-05 19:09:31 Re: Book