Re: PGbackrest very slow!
| От | Pär Mattsson |
|---|---|
| Тема | Re: PGbackrest very slow! |
| Дата | |
| Msg-id | CAE9BupywH1fvqwRe-So7zhS1LqjOFFv3SVZuPHP=Ehbcb+ZJ2g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PGbackrest very slow! ("DINESH NAIR" <Dinesh_Nair@iitmpravartak.net>) |
| Список | 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@iitmpravartak.net>:
Hi,Kindly try changing below mentioned parameters.Parallel-process= -- based on the CPU CORE
compress-type=lz4
compress-level= -- based on the CPU COREThanks & Regards
Dinesh Nair
From: Pär 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!
You don't often get email from par.x.mattsson@gmail.com. Learn why this is importantCaution: 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ärMvh PärFrån: Scott Ribe <scott_ribe@elevated-dev.com>
Skickat: Thursday, October 23, 2025 3:14:20 PM
Till: Pär Mattsson <par.x.mattsson@gmail.com>
Kopia: pgsql-admin <pgsql-admin@postgresql.org>
Ämne: Re: PGbackrest very slow!> On Oct 23, 2025, at 2:59 AM, Pär Mattsson <par.x.mattsson@gmail.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
В списке pgsql-admin по дате отправления: