public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pär Mattsson <[email protected]>
To: DINESH NAIR <[email protected]>
Cc: Scott Ribe <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: PGbackrest very slow!
Date: Fri, 24 Oct 2025 14:36:46 +0200
Message-ID: <CAE9BupywH1fvqwRe-So7zhS1LqjOFFv3SVZuPHP=Ehbcb+ZJ2g@mail.gmail.com> (raw)
In-Reply-To: <PN4P287MB43814D3FD9032859913C6A9A9CF1A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
References: <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>
<[email protected]>
<AM0PR03MB555691074192002C7FF4681BA2F0A@AM0PR03MB5556.eurprd03.prod.outlook.com>
<PN4P287MB43814D3FD9032859913C6A9A9CF1A@PN4P287MB4381.INDP287.PROD.OUTLOOK.COM>
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 <
[email protected]>:
> 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 <[email protected]>
> *Sent:* Thursday, October 23, 2025 7:21 PM
> *To:* Scott Ribe <[email protected]>
> *Cc:* pgsql-admin <[email protected]>
> *Subject:* Re: PGbackrest very slow!
>
> You don't often get email from [email protected]. 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 <[email protected]>
> *Skickat:* Thursday, October 23, 2025 3:14:20 PM
> *Till:* Pär Mattsson <[email protected]>
> *Kopia:* pgsql-admin <[email protected]>
> *Ämne:* Re: PGbackrest very slow!
>
> > On Oct 23, 2025, at 2:59 AM, Pär Mattsson <[email protected]>
> 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
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PGbackrest very slow!
In-Reply-To: <CAE9BupywH1fvqwRe-So7zhS1LqjOFFv3SVZuPHP=Ehbcb+ZJ2g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox