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