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

From Pär Mattsson
Subject Re: PGbackrest very slow!
Date
Msg-id CAE9BupywH1fvqwRe-So7zhS1LqjOFFv3SVZuPHP=Ehbcb+ZJ2g@mail.gmail.com
Whole thread Raw
In response to Re: PGbackrest very slow!  ("DINESH NAIR" <Dinesh_Nair@iitmpravartak.net>)
List pgsql-admin
Hi! 

[global]

repo1-path=/postgresql/backup

repo1-retention-full=2

start-fast=y

process-max=4


When I deleted  backup-standby=y and increased process-max=4 , then the backup took 7 min of 50GB.


I will test all your tips! Thanks alot!

Br Pär


Den fre 24 okt. 2025 kl 04:15 skrev DINESH NAIR <Dinesh_Nair@iitmpravartak.net>:
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!
 
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: Ishan Arunkumar Joshi
Date:
Subject: RE: postgres server crash with "Segmentation fault"