Re: PGbackrest very slow!

From: "DINESH NAIR" <Dinesh_Nair(at)iitmpravartak(dot)net>
To: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGbackrest very slow!
Date: 2025-10-24 02:15:22
Message-ID: PN4P287MB43814D3FD9032859913C6A9A9CF1A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)x(dot)mattsson(at)gmail(dot)com>
Sent: Thursday, October 23, 2025 7:21 PM
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGbackrest very slow!

You don't often get email from par(dot)x(dot)mattsson(at)gmail(dot)com(dot) Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
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(at)elevated-dev(dot)com>
Skickat: Thursday, October 23, 2025 3:14:20 PM
Till: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
Kopia: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Ämne: Re: PGbackrest very slow!

> On Oct 23, 2025, at 2:59 AM, Pär Mattsson <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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ishan Arunkumar Joshi 2025-10-24 06:24:08 RE: postgres server crash with "Segmentation fault"
Previous Message Pär Mattsson 2025-10-23 18:07:40 Re: PGbackrest very slow!