Stephen Frost <sfrost@xxxxxxxxxxx> wrote on 2019/10/11 08:50:53 AM:
> From: Stephen Frost <sfrost@xxxxxxxxxxx>
> To: Ajay Pratap <ajaypratap@xxxxxxxxx>
> Cc: Postgres General <pgsql-general@xxxxxxxxxxxxxx>
> Date: 2019/10/11 08:51 AM
> Subject: [EXTERNAL] Re: Pgbackrest backup is too slow
>
> Greetings,
>
> * Ajay Pratap (ajaypratap@xxxxxxxxx) 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.
