Request a Demo
Home   >   mailing lists

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

From DINESH NAIR
Subject Re: PGbackrest very slow!
Date
Msg-id PN4P287MB43814D3FD9032859913C6A9A9CF1A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: PGbackrest very slow!  (Pär Mattsson <par.x.mattsson@gmail.com>)
Responses Re: PGbackrest very slow!
List pgsql-admin
Tree view
Hi,

Kindly try changing below mentioned parameters.



Parallel-process=      -- based on the CPU CORE
compress-type=lz4
compress-level=       -- based on the CPU CORE


Thanks & Regards

Dinesh Nair

From: Pär Mattsson <par.x.mattsson@gmail.com>
Sent: Thursday, October 23, 2025 7:21 PM
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: PGbackrest very slow!
 
You don't often get email from par.x.mattsson@gmail.com. Learn why this is important
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
Thanks I will test that!
Br Pär

Mvh Pär
Från: Scott Ribe <scott_ribe@elevated-dev.com>
Skickat: Thursday, October 23, 2025 3:14:20 PM
Till: Pär Mattsson <par.x.mattsson@gmail.com>
Kopia: pgsql-admin <pgsql-admin@postgresql.org>
Ämne: Re: PGbackrest very slow!
 
> 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

pgsql-admin by date:

Previous
From: Pär Mattsson
Date:
Subject: Re: PGbackrest very slow!
Next
From: Ishan Arunkumar Joshi
Date:
Subject: RE: postgres server crash with "Segmentation fault"