Postgres Pro
Downloads
Home   >   mailing lists

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

From Muhammad Usman Khan
Subject Re: Parallelize WAL Sender and WAL receiver
Date
Msg-id CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com
Whole thread Raw
In response to Parallelize WAL Sender and WAL receiver  (Karthik Yellapragada <karthik.yellapragada@gmail.com>)
Responses Re: Parallelize WAL Sender and WAL receiver
List pgsql-admin
Tree view
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.yellapragada@gmail.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

pgsql-admin by date:

Previous
From: Sam Stearns
Date:
Subject: Re: Book
Next
From: Muhammad Usman Khan
Date:
Subject: Re: Incremental load from SQL server DB to postgressql