MIME-Version: 1.0
References: 
 <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>
 <253B8247-76FC-4827-B8D2-4AD5EFF639EF@elevated-dev.com>
In-Reply-To: <253B8247-76FC-4827-B8D2-4AD5EFF639EF@elevated-dev.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 23 Oct 2025 10:21:37 -0400
Message-ID: 
 <CANzqJaDqRbD4OgF84CKQ+MQNMYZydnkH=gr7Os=BpWhARG8fwg@mail.gmail.com>
Subject: Re: PGbackrest very slow!
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005417e80641d4275b"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDqRbD4OgF84CKQ%2BMQNMYZydnkH%3Dgr7Os%3DBpWhARG8fwg%40mail.gmail.com>
Precedence: bulk

--0000000000005417e80641d4275b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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@=
gmail.com>
> wrote:
> >
> > ...
> > The backup of 50GB took 40 min.
> > It is not a network issue. I tested to transfer 2GB between two host an=
d
> it took 4 sec.
> >
> > I think backup-standby=3Dy slows down the backup out of all minds.
> >
> > Br P=C3=A4r
>
> pgbackrest defaults to gzip compression, which is slow--try lz4 and see
> what 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!

--0000000000005417e80641d4275b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Oct 23, 2025 at 9:14=E2=80=AFAM S=
cott Ribe &lt;<a href=3D"mailto:scott_ribe@elevated-dev.com">scott_ribe@ele=
vated-dev.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">&gt; On Oct 23, 2=
025, at 2:59=E2=80=AFAM, P=C3=A4r Mattsson &lt;<a href=3D"mailto:par.x.matt=
sson@gmail.com" target=3D"_blank">par.x.mattsson@gmail.com</a>&gt; wrote:<b=
r>
&gt; <br>
&gt; ...<br>
&gt; The backup of 50GB took 40 min.<br>
&gt; It is not a network issue. I tested to transfer 2GB between two host a=
nd it took 4 sec.<br>
&gt; <br>
&gt; I think backup-standby=3Dy slows down the backup out of all minds.<br>
&gt; <br>
&gt; Br P=C3=A4r<br>
<br>
pgbackrest defaults to gzip compression, which is slow--try lz4 and see wha=
t happens<br>
</blockquote></div><div><br clear=3D"all"></div><div>lz4 is faster, but not=
 1440x faster.</div><div><br></div><span class=3D"gmail_signature_prefix">-=
- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">De=
ath to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m s=
till alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div><=
/div></div>

--0000000000005417e80641d4275b--