Re: Parallel WAL Archival Options

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: "Michaeldba(at)sqlexec(dot)com" <MichaelDBA(at)sqlexec(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Parallel WAL Archival Options
Date: 2023-08-06 10:56:43
Message-ID: CAFpL5Vz0oDBgNP5UTShf6y8MzMm4z0Di0ZBFFVYR67QaJ_YObA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Michael,

May I know what is wal generation rate pm for you? I may give this a try.

Thanks,
Nikhil

On Sun, 6 Aug 2023 at 13:56, Michaeldba(at)sqlexec(dot)com <Michaeldba(at)sqlexec(dot)com>
wrote:

> I am using PGbackrest and I am generating many WALs per second too, and I
> have no problems keeping up and I am backing them up remotely.
>
> Sent from my iPad
>
> > On Aug 6, 2023, at 3:43 AM, Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
> wrote:
> >
> > Hi Team,
> >
> > I would like to know which backup&restore tools will be better for
> scenarios where the database is generating around 400 WALs per minute.
> >
> > We are using wal-g but it is not able to keep pace with the wal
> generation. We increased the upload streams to 256 but no luck
> >
> > Thanks,
> > Nikhil
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2023-08-06 12:55:10 Re: Parallel WAL Archival Options
Previous Message Nikhil Shetty 2023-08-06 10:54:58 Re: Parallel WAL Archival Options