Re: Parallelize WAL Sender and WAL receiver

From: Keith <keith(at)keithf4(dot)com>
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-05 01:41:37
Message-ID: CAHw75vu+DxaY-fNGT0br4uEcLj+ky1GM=xxge-3+08RWdVtYsQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Sep 4, 2024 at 9:04 PM 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
>

Take a look at pgBackRest. It provides an option for asynchronous WAL
archiving and retrieval. The actual replay of the WAL is always single
threaded.

https://pgbackrest.org/

Keith

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2024-09-05 01:52:01 Re: Parallelize WAL Sender and WAL receiver
Previous Message Ron Johnson 2024-09-05 01:34:03 Re: Parallelize WAL Sender and WAL receiver