Date: Thu, 23 Oct 2025 09:25:18 -0500
From: Ken Marshall <ktm@rice.edu>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: PGbackrest very slow!
Message-ID: <aPo6zteTjkbE4uRs@customer.dllstxx1.isp.starlink.com>
References: 
 <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>
 <253B8247-76FC-4827-B8D2-4AD5EFF639EF@elevated-dev.com>
 <CANzqJaDqRbD4OgF84CKQ+MQNMYZydnkH=gr7Os=BpWhARG8fwg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CANzqJaDqRbD4OgF84CKQ+MQNMYZydnkH=gr7Os=BpWhARG8fwg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/aPo6zteTjkbE4uRs%40customer.dllstxx1.isp.starlink.com>
Precedence: bulk

On Thu, Oct 23, 2025 at 10:21:37AM -0400, Ron Johnson wrote:
> On Thu, Oct 23, 2025 at 9:14 AM Scott Ribe <scott_ribe@elevated-dev.com>
> wrote:
> 
> > > 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
> >
> 
> lz4 is faster, but not 1440x faster.
> 

But it might be 24x faster, using 2s/GB. :)

--Ken