Re: Pgbackrest backup is too slow

Stephen Frost <sfrost@snowman.net> wrote on 2019/10/11 08:50:53 AM:

> From: Stephen Frost <sfrost@snowman.net>
> To: Ajay Pratap <ajaypratap@ameyo.com>
> Cc: Postgres General <pgsql-general@postgresql.org>
> Date: 2019/10/11 08:51 AM
> Subject: [EXTERNAL] Re: Pgbackrest backup is too slow
>
> Greetings,
>
> * Ajay Pratap (ajaypratap@ameyo.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.