Re: PGbackrest very slow!

From: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
To: adnan salam <adnan_pk_1(at)yahoo(dot)com>, "ronljohnsonjr(at)gmail(dot)com" <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PGbackrest very slow!
Date: 2025-10-23 18:07:40
Message-ID: AM0PR03MB5556B3B64846514A22F918E2A2F0A@AM0PR03MB5556.eurprd03.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks

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

Hi,

Increase the Parallel processes for pg back rest backup.

Regards,
Adnan

Yahoo Mail: Search, organise, conquer<https://mail.onelink.me/107872968?pid=nativeplacement&c=US_Acquisition_YMktg_315_SearchOrgConquer_EmailSignature&af_sub1=Acquisition&af_sub2=US_YMktg&af_sub3=&af_sub4=100002039&af_sub5=C01_Email_Static_&af_ios_store_cpp=0c38e4b0-a27e-40f9-a211-f4e2de32ab91&af_android_url=https://play.google.com/store/apps/details?id=com.yahoo.mobile.client.android.mail&listing=search_organize_conquer>

On Thu, 23 Oct 2025 at 19:22, Ron Johnson
<ronljohnsonjr(at)gmail(dot)com> wrote:
On Thu, Oct 23, 2025 at 9:14 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com<mailto:scott_ribe(at)elevated-dev(dot)com>> wrote:
> On Oct 23, 2025, at 2:59 AM, Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com<mailto:par(dot)x(dot)mattsson(at)gmail(dot)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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DINESH NAIR 2025-10-24 02:15:22 Re: PGbackrest very slow!
Previous Message adnan salam 2025-10-23 17:54:40 Re: PGbackrest very slow!