From: | Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_basebackup is taking more time than expected |
Date: | 2018-01-13 16:32:47 |
Message-ID: | CAEHH7R5dGa=iZyD4M-F09vZAzY337v3Kk2HAqdfCxN+PT+Fj2g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you very much for your prompt response.
I am asking in my previous mail as, Does the pg_basebackup depends on any
of the postgres configuration parameters likes shared
buffer/maintanance_work_memory etc? If yes, which are those configuration
parameters, I need to take care/increase the value?
Please let me know what does this means.
*Please don't top-post on the PG mailing lists.*
*How to get clarifications on my query?*
On Sat, Jan 13, 2018 at 9:52 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> Greetings,
>
> Please don't top-post on the PG mailing lists.
>
> * Raghavendra Rao J S V (raghavendrajsv(at)gmail(dot)com) wrote:
> > pg_basebackup utility depends on which are the parameters?
>
> I'm not sure what you're asking here.
>
> > Is there any possibility to run the pg_basebackup in multi thread?
>
> No, not today. There's been discussion about making it multi-threaded
> but I seriously doubt that'll happen for v11 at this point.
>
> > To improve the speed of the backup of database using pg_basebackup
> utility
> > we shutdown the database and started alone database services. Till that
> > time other sevices won't run. We observed some improvement but any other
> > things we need to perform to reduce the time taken by the pg_basebackup
> > utility.
>
> Sure, reducing the load of the system might make pg_basebackup a little
> faster, but seems unlikely to help it a lot in this case, and it means
> you have downtime which might not be ideal.
>
> > We are using below command to take the backup of the database. Any
> > improvements to reduce the time taken by backup statement.
> >
> > $PGHOME/bin/pg_basebackup -p 5433 -U postgres -P -v -x --format=tar
> --gzip
> > --compress=6 --pgdata=- -D /opt/backup_db
>
> Might be faster if you didn't compress it, but, of course, then you
> wouldn't have a compressed backup.
>
> This is exactly the kind of issue that lead to the development of
> pgBackRest. Larger databases really do need multi-threaded backups and
> there weren't any backup tools for PG which were multi-threaded when we
> started. There's a few other options now, which is good, but
> pg_basebackup isn't one of them.
>
> Thanks!
>
> Stephen
>
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2018-01-13 16:41:46 | Re: pg_basebackup is taking more time than expected |
Previous Message | Stephen Frost | 2018-01-13 16:22:21 | Re: pg_basebackup is taking more time than expected |