Re: Pgbackrest backup is too slow

Stephen Frost <sfrost(at)snowman(dot)net> wrote on 2019/10/11 08:50:53 AM:

> From: Stephen Frost <sfrost(at)snowman(dot)net>
> To: Ajay Pratap <ajaypratap(at)ameyo(dot)com>
> Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
> Date: 2019/10/11 08:51 AM
> Subject: [EXTERNAL] Re: Pgbackrest backup is too slow
>
> Greetings,
>
> * Ajay Pratap (ajaypratap(at)ameyo(dot)com) wrote:
> > I have a Centos 7 server which runs Postgresql 10.7. I am using
pgbackrest
> > to take db backup.
> > Problem is backup is too slow.
>
> Have you tried running 'top' to see what's going on?
>
> > My data dir size is 9.6G and full backup runtime is 22 mins
> > I also tried using process-max=3, full backup runtime = 21 mins
>
> Erm, those numbers don't make any sense to me- as an example, we
> regularly back up a 12GB database, from Dallas to San Fran, in 5
> minutes.

How many database objects do you have? For databases with a lot of tables
and/or indexes (think tens of thousands), backup performance will slow
down. This has improved a lot in newer versions, but still impacts
performance of the backups.

Brad.