Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vCH2Y-00BV2Z-5n for pgsql-admin@arkaria.postgresql.org; Fri, 24 Oct 2025 12:37:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vCH2W-00G0j5-Od for pgsql-admin@arkaria.postgresql.org; Fri, 24 Oct 2025 12:37:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vCH2W-00G0iv-6X for pgsql-admin@lists.postgresql.org; Fri, 24 Oct 2025 12:37:03 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCH2S-003zXn-1H for pgsql-admin@postgresql.org; Fri, 24 Oct 2025 12:37:02 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-4298bada5bdso1602896f8f.2 for ; Fri, 24 Oct 2025 05:36:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761309419; x=1761914219; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=yw/lormw0fYtK3sv5unEKoqYrJv0EpkHqlaib32Onh8=; b=XuuhYRiG9kNnvQ5dMBoNO7VFHLSLClxPleMHESqua0zFIL1MoU/+WQlD3HC9jKfOLs TkAnOhjPQpCbklMwQ1BN0tKxrf632fUtu7PIko6Y5AN5iKB1NJuU5K+fDGbBH78X7Hqb kIIeOtUmjtD3EBgK8i3v4JulUlyKuBgn9eui7YCMbS23BYTlJHbLFKmn0cY71vwAPkNA 28D1/TebvfnNXF/O/0nAHqobyFjRiUCpFvNfvPdi32VnSbfbQD8tBOh5kBpcTiPc8e46 0k/m8w3+C3LOeIDWADRFugigRGVfVAcomtb+jCE9vVA8b/Q00UlN3CIgPMoXntRHBtft gQMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761309419; x=1761914219; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=yw/lormw0fYtK3sv5unEKoqYrJv0EpkHqlaib32Onh8=; b=f2+8AjMQ2Rio9amZvvfLny14xaBEsCZ5rRihpFvm8P/Ti7UwmeyWOIO4zA+Gzvl6kx rrrREDiOaKmein/SoijYuomHfNjGdV2Y/n8oKtxoWaWhJFk+PXMrPFunxhDZIgW0dq9U fghsb1nVgUzkjBj9kOHNkWTpjSTzITGjT/aFTKdgzfcmgIuIbGpJ/iQpEpRKHKwrNZ/E sv4pJG6LFnxRgiVoicszIhXOl6IlvGJdVN2C8EWcyFWebN9c4I4tBIektumrc1DhOzmR XHlTFQcZPM7ae1JAleGnhV9Z23BM2gLRIzOdHW0dx9078SKVHD3lc4pkWtmaQwE2gN6r NiBw== X-Forwarded-Encrypted: i=1; AJvYcCWEkzz9qbCm0DvjrQL3zMw668C3y84XGDgf0+hrXgXwZxuIzrvyrQC/7EbBNPEb1WKVt0/NeVS213cA3g==@postgresql.org X-Gm-Message-State: AOJu0YwJluRDwcHbikNbPXDNCIgh8IInfeV6/TUl5+yJHGVpLnVWnhXX yWvHm60H0TFGHb8HwXWv0uAfqhjKR9eN/8FGmSwb9b7QA6CzWWFzg+bim7Anp296mguhKPXEr3b H8fHfsyRCUp3UduaiELFqO7ALmg6ewgM= X-Gm-Gg: ASbGncuz8ipEriUrlHMGXOOjt0UcgcvJBPbZdK3xU7OcETox0rrA9jl40+h/5AErjGR einu/QWbB954IDJxuRg0ST9/TTV8ZAwfCR7Fa8veRvHhyxMe9h2vm2JNqC6Ufgk5OYjBFKFN2BB ZBybTyBZSNvsQDoMCSPLXy1sM6p3qRcdwpdhvYk2Hf+3VY7dCZTRS46KhzWXPyJds2hkLKAzYL8 qiauepGHJpRDm4r4S77r9/hDlbVTHP3vXGu7wSXGujstKACO4HSTNseASVXuRWxjl0= X-Google-Smtp-Source: AGHT+IGndaT2mZzEUq0BONbzI3BtbJpoNAQbMmOdcqb7qqiSydgzvTzSNo7ag+ErKnovcfpLiq2qp1k2oRMU3aInPBQ= X-Received: by 2002:a5d:5d82:0:b0:428:4004:8226 with SMTP id ffacd0b85a97d-4284004ab91mr13758843f8f.34.1761309418475; Fri, 24 Oct 2025 05:36:58 -0700 (PDT) MIME-Version: 1.0 References: <253B8247-76FC-4827-B8D2-4AD5EFF639EF@elevated-dev.com> In-Reply-To: From: =?UTF-8?Q?P=C3=A4r_Mattsson?= Date: Fri, 24 Oct 2025 14:36:46 +0200 X-Gm-Features: AWmQ_bmN7ZKyJd3i4js8UparEgtiekqLaFnD1S6A1t_msLThw-7iYNFCOLYMuwE Message-ID: Subject: Re: PGbackrest very slow! To: DINESH NAIR Cc: Scott Ribe , pgsql-admin Content-Type: multipart/alternative; boundary="0000000000003a535a0641e6ce5d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003a535a0641e6ce5d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi! [global] repo1-path=3D/postgresql/backup repo1-retention-full=3D2 start-fast=3Dy process-max=3D4 When I deleted backup-standby=3Dy and increased process-max=3D4 , then the backup took 7 min of 50GB. I will test all your tips! Thanks alot! Br P=C3=A4r Den fre 24 okt. 2025 kl 04:15 skrev DINESH NAIR < Dinesh_Nair@iitmpravartak.net>: > Hi, > > Kindly try changing below mentioned parameters. > > > > Parallel-process=3D -- based on the CPU CORE > compress-type=3Dlz4 > compress-level=3D -- based on the CPU CORE > > > Thanks & Regards > > Dinesh Nair > ------------------------------ > *From:* P=C3=A4r Mattsson > *Sent:* Thursday, October 23, 2025 7:21 PM > *To:* Scott Ribe > *Cc:* pgsql-admin > *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=E2=80=99s identity before clicking links or opening attachments. > Thanks I will test that! > Br P=C3=A4r > > Mvh P=C3=A4r > ------------------------------ > *Fr=C3=A5n:* Scott Ribe > *Skickat:* Thursday, October 23, 2025 3:14:20 PM > *Till:* P=C3=A4r Mattsson > *Kopia:* pgsql-admin > *=C3=84mne:* Re: PGbackrest very slow! > > > On Oct 23, 2025, at 2:59=E2=80=AFAM, P=C3=A4r Mattsson > wrote: > > > > ... > > The backup of 50GB took 40 min. > > It is not a network issue. I tested to transfer 2GB between two host an= d > it took 4 sec. > > > > I think backup-standby=3Dy slows down the backup out of all minds. > > > > Br P=C3=A4r > > pgbackrest defaults to gzip compression, which is slow--try lz4 and see > what happens > > --0000000000003a535a0641e6ce5d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi!=C2= =A0

[global]

repo1-path=3D/postgresql/backup

repo1-retention-full=3D2

start-fast=3Dy

process-max=3D4


When I deleted=C2=A0 backup-standby=3Dy a= nd increased process-max=3D4 , then the backup took 7 min of 50GB.


I will test all your tips!= Thanks alot!

Br P=C3=A4r


Den fre 2= 4 okt. 2025 kl 04:15 skrev DINESH NAIR <Dinesh_Nair@iitmpravartak.net>:
Hi,

Kindly try changing below mentioned parameters.



Parallel-process=3D=C2=A0 =C2=A0 =C2=A0 -- based on the CPU CORE
compress-type=3Dlz4
compress-level=3D=C2=A0 =C2=A0 =C2=A0 =C2=A0-- based on the CPU CORE


Thanks & Regards

Dinesh Nair

From:= P=C3=A4r 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!
=C2=A0
Caution: This email was sent from a= n external source. Please verify the sender=E2=80=99s identity before click= ing links or opening attachments.
Thanks I will test that!
Br P=C3=A4r

Mvh P=C3=A4r
Fr=C3= =A5n: Scott Ribe <scott_ribe@elevated-dev.com>
Skickat: Thursday, October 23, 2025 3:14:20 PM
Till: P=C3=A4r Mattsson <par.x.mattsson@gmail.com>
Kopia: pgsql-admin <pgsql-admin@postgresql.org>
=C3=84mne: Re: PGbackrest very slow!
=C2=A0
> On Oct 23, 2025, at 2:59=E2=80=AFAM, P=C3=A4r Mattsson <par.x.mattsson@gmai= l.com> wrote:
>
> ...
> The backup of 50GB took 40 min.
> It is not a network issue. I tested to transfer 2GB between two host a= nd it took 4 sec.
>
> I think backup-standby=3Dy slows down the backup out of all minds.
>
> Br P=C3=A4r

pgbackrest defaults to gzip compression, which is slow--try lz4 and see wha= t happens

--0000000000003a535a0641e6ce5d--