public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ilya Kosmodemiansky <[email protected]>
To: Pär Mattsson <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: PGbackrest very slow!
Date: Thu, 23 Oct 2025 11:54:42 +0200
Message-ID: <CAG95seVdRDzVnZ9iqzrh4oZ8XHRF950CcrSdRHOgC9MmXFgCDg@mail.gmail.com> (raw)
In-Reply-To: <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>
References: <CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com>

Hi Pär,

On Thu, Oct 23, 2025 at 10:59 AM Pär Mattsson <[email protected]> wrote:
>
> Hi!
> I have  3 node postgres cluster with repmgr and pgpool.
>
> Pgbackrest is configed like this
> We use pgbackrest with this config
> =======================================

It is a quite basic config,

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

so if you are sure it is not a network issue, your guess could be
right. You can try to compare with backup from primary and if it is
faster, it could be archiving process on standby which slows you down.
You can try to improve it with more processes [1] and with better zst
compression [2]. Async archiving [3] could also help

>
> Br Pär
>
>

[1] https://pgbackrest.org/configuration.html#section-general/option-process-max
[2] https://pgbackrest.org/configuration.html#section-general/option-compress
[3] https://pgbackrest.org/configuration.html#section-archive/option-archive-async


best regards,
Ilya Kosmodemiansky
CEO, Founder

Data Egret GmbH
Your remote PostgreSQL DBA team
T.: +49 6821 919 3297
[email protected]

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]
  Subject: Re: PGbackrest very slow!
  In-Reply-To: <CAG95seVdRDzVnZ9iqzrh4oZ8XHRF950CcrSdRHOgC9MmXFgCDg@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