Re: PGbackrest very slow!

From: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
To: DINESH NAIR <Dinesh_Nair(at)iitmpravartak(dot)net>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGbackrest very slow!
Date: 2025-10-24 12:36:46
Message-ID: CAE9BupywH1fvqwRe-So7zhS1LqjOFFv3SVZuPHP=Ehbcb+ZJ2g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)iitmpravartak(dot)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(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

Browse pgsql-admin by date

  From Date Subject
Next Message Pär Mattsson 2025-10-27 17:09:30 Huge database, archive system.
Previous Message Ishan Arunkumar Joshi 2025-10-24 06:24:08 RE: postgres server crash with "Segmentation fault"