| 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
| 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! |