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