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
>
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 |