Date: Thu, 23 Oct 2025 17:54:40 +0000 (UTC)
From: adnan salam <adnan_pk_1@yahoo.com>
Reply-To: adnan salam <adnan_pk_1@yahoo.com>
To: ronljohnsonjr@gmail.com, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <1421479102.25158.1761242080409@mail.yahoo.com>
In-Reply-To: 
 <CANzqJaDqRbD4OgF84CKQ+MQNMYZydnkH=gr7Os=BpWhARG8fwg@mail.gmail.com>
References: 
 <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>
 <253B8247-76FC-4827-B8D2-4AD5EFF639EF@elevated-dev.com>
 <CANzqJaDqRbD4OgF84CKQ+MQNMYZydnkH=gr7Os=BpWhARG8fwg@mail.gmail.com>
Subject: Re: PGbackrest very slow!
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_25157_142189255.1761242080408"
Content-Length: 4152
Archived-At: 
 <https://www.postgresql.org/message-id/1421479102.25158.1761242080409%40mail.yahoo.com>
Precedence: bulk

------=_Part_25157_142189255.1761242080408
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,
Increase the Parallel processes for pg back rest backup.
Regards,Adnan

Yahoo Mail: Search, organise, conquer=20
=20
  On Thu, 23 Oct 2025 at 19:22, Ron Johnson<ronljohnsonjr@gmail.com> wrote:=
   On Thu, Oct 23, 2025 at 9:14=E2=80=AFAM Scott Ribe <scott_ribe@elevated-=
dev.com> wrote:
> On Oct 23, 2025, at 2:59=E2=80=AFAM, P=C3=A4r Mattsson <par.x.mattsson@gm=
ail.com> wrote:
>=20
> ...
> 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.
>=20
> I think backup-standby=3Dy slows down the backup out of all minds.
>=20
> Br P=C3=A4r

pgbackrest defaults to gzip compression, which is slow--try lz4 and see wha=
t happens


lz4 is faster, but not 1440x faster.
--=20
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobster! =20

------=_Part_25157_142189255.1761242080408
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,<div><br></div><div>Increase the Parallel processes for pg back rest bac=
kup.</div><div><br></div><div>Regards,</div><div>Adnan<br><br><div id=3D"ym=
ail_android_signature"><a id=3D"ymail_android_signature_link" href=3D"https=
://mail.onelink.me/107872968?pid=3Dnativeplacement&amp;c=3DUS_Acquisition_Y=
Mktg_315_SearchOrgConquer_EmailSignature&amp;af_sub1=3DAcquisition&amp;af_s=
ub2=3DUS_YMktg&amp;af_sub3=3D&amp;af_sub4=3D100002039&amp;af_sub5=3DC01_Ema=
il_Static_&amp;af_ios_store_cpp=3D0c38e4b0-a27e-40f9-a211-f4e2de32ab91&amp;=
af_android_url=3Dhttps://play.google.com/store/apps/details?id=3Dcom.yahoo.=
mobile.client.android.mail&amp;listing=3Dsearch_organize_conquer">Yahoo Mai=
l: Search, organise, conquer</a></div> <br> <blockquote style=3D"margin: 0 =
0 20px 0;"> <div style=3D"font-family:Roboto, sans-serif; color:#6D00F6;"> =
<div>On Thu, 23 Oct 2025 at 19:22, Ron Johnson</div><div>&lt;ronljohnsonjr@=
gmail.com&gt; wrote:</div> </div> <div style=3D"padding: 10px 0 0 20px; mar=
gin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div id=3D"yiv6794156123=
"><div><div dir=3D"ltr"><div id=3D"yiv6794156123yqt29554" class=3D"yiv67941=
56123yqt3848945642"><div dir=3D"ltr">On Thu, Oct 23, 2025 at 9:14=E2=80=AFA=
M Scott Ribe &lt;<a rel=3D"nofollow noopener noreferrer" shape=3D"rect" yma=
ilto=3D"mailto:scott_ribe@elevated-dev.com" target=3D"_blank" href=3D"mailt=
o:scott_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>&gt; wrote:</=
div><div class=3D"yiv6794156123gmail_quote yiv6794156123gmail_quote_contain=
er"><blockquote style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb=
(204,204,204);padding-left:1ex;" class=3D"yiv6794156123gmail_quote">&gt; On=
 Oct 23, 2025, at 2:59=E2=80=AFAM, P=C3=A4r Mattsson &lt;<a rel=3D"nofollow=
 noopener noreferrer" shape=3D"rect" ymailto=3D"mailto:par.x.mattsson@gmail=
.com" target=3D"_blank" href=3D"mailto:par.x.mattsson@gmail.com">par.x.matt=
sson@gmail.com</a>&gt; wrote:<br clear=3D"none">
&gt; <br clear=3D"none">
&gt; ...<br clear=3D"none">
&gt; The backup of 50GB took 40 min.<br clear=3D"none">
&gt; It is not a network issue. I tested to transfer 2GB between two host a=
nd it took 4 sec.<br clear=3D"none">
&gt; <br clear=3D"none">
&gt; I think backup-standby=3Dy slows down the backup out of all minds.<br =
clear=3D"none">
&gt; <br clear=3D"none">
&gt; Br P=C3=A4r<br clear=3D"none">
<br clear=3D"none">
pgbackrest defaults to gzip compression, which is slow--try lz4 and see wha=
t happens<br clear=3D"none">
</blockquote></div></div><div><br clear=3D"all"></div><div>lz4 is faster, b=
ut not 1440x faster.</div><div><br clear=3D"none"></div><span class=3D"yiv6=
794156123gmail_signature_prefix">-- </span><br clear=3D"none"><div dir=3D"l=
tr" class=3D"yiv6794156123gmail_signature"><div dir=3D"ltr">Death to &lt;Re=
dacted&gt;, and butter sauce.<div>Don't boil me, I'm still alive.<br clear=
=3D"none"><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div>=
</div>
</div></div> </div> </blockquote></div>
------=_Part_25157_142189255.1761242080408--