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