PGbackrest very slow! - Mailing list pgsql-admin

From Pär Mattsson
Subject PGbackrest very slow!
Date
Msg-id CAE9Bupympsqn=7emjt6T5ug6dg1yKKsBRTx9Venf2cZWULZQtw@mail.gmail.com
Whole thread Raw
Responses Re: PGbackrest very slow!
Re: PGbackrest very slow!
List pgsql-admin
Hi!
I have  3 node postgres cluster with repmgr and pgpool.

Pgbackrest is configed like this
We use pgbackrest with this config
=======================================

[global]

backup-standby=y

repo1-path=/postgresql/backup

repo1-retention-full=2

start-fast=y

 

[PG]

pg1-path=/postgresql/data

pg2-host=node2

pg2-host-user=postgres

pg2-path=/postgresql/data

pg3-host=node3

pg3-host-user=postgres

pg3-path=/postgresql/data

=================================================

I run the backuplike this


/usr/bin/pgbackrest --log-level-console=detail --stanza=PG --type=full backup

 


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

 

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: does BUG #18942 and BUG #18938 solution available in Pg16 latest release 16.10
Next
From: Ilya Kosmodemiansky
Date:
Subject: Re: PGbackrest very slow!