Request a Demo
Home   >   mailing lists

Re: PGbackrest very slow! - Mailing list pgsql-admin

From Pär Mattsson
Subject Re: PGbackrest very slow!
Date
Msg-id AM0PR03MB5556B3B64846514A22F918E2A2F0A@AM0PR03MB5556.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: PGbackrest very slow!  (adnan salam <adnan_pk_1@yahoo.com>)
List pgsql-admin
Tree view
Thanks 

Mvh Pär
Från: adnan salam <adnan_pk_1@yahoo.com>
Skickat: Thursday, October 23, 2025 7:54:40 PM
Till: ronljohnsonjr@gmail.com <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Ämne: Re: PGbackrest very slow!
 
Hi,

Increase the Parallel processes for pg back rest backup.

Regards,
Adnan


On Thu, 23 Oct 2025 at 19:22, Ron Johnson
<ronljohnsonjr@gmail.com> wrote:
On Thu, Oct 23, 2025 at 9:14 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Oct 23, 2025, at 2:59 AM, Pär Mattsson <par.x.mattsson@gmail.com> wrote:
>
> ...
> The backup of 50GB took 40 min.
> It is not a network issue. I tested to transfer 2GB between two host and it took 4 sec.
>
> I think backup-standby=y slows down the backup out of all minds.
>
> Br Pär

pgbackrest defaults to gzip compression, which is slow--try lz4 and see what happens

lz4 is faster, but not 1440x faster.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: adnan salam
Date:
Subject: Re: PGbackrest very slow!
Next
From: "DINESH NAIR"
Date:
Subject: Re: PGbackrest very slow!