Обсуждение: pg_basebackup running slow
Hello,
We are using postgresql 9.2 on redhat linux instance over openstack cloud.
Database is around 441 GB.
We are using below command to take backup:
pg_basebackup -v -D /pgbackup/$bkupdir -Ft -z -c fast
Backup size created is around 84GB.
However, it is taking almost 10 hr 21 minutes to complete.
Looking for speed improvement?
Thanks& Regards,
Vaze Swapnil
What is the settings for max_wal_sender?
you can try increasing this parameter to improve backup performance.
Thanks,
Samir Magar
On Fri, Oct 14, 2016 at 6:05 PM, Swapnil Vaze <swapvaze28@gmail.com> wrote:
Hello,
We are using postgresql 9.2 on redhat linux instance over openstack cloud.
Database is around 441 GB.
We are using below command to take backup:
pg_basebackup -v -D /pgbackup/$bkupdir -Ft -z -c fast
Backup size created is around 84GB.
However, it is taking almost 10 hr 21 minutes to complete.
Looking for speed improvement?
Thanks& Regards,
Vaze Swapnil
On Fri, Oct 14, 2016 at 10:21 PM, Samir Magar <samirmagar8@gmail.com> wrote: > What is the settings for max_wal_sender? > you can try increasing this parameter to improve backup performance. max_wal_senders has no influence on the performance of a base backup taken as a base backup is just sent through one single WAL sender process. What matters here is the network bandwidth. -- Michael
Vaze, * Swapnil Vaze (swapvaze28@gmail.com) wrote: > We are using postgresql 9.2 on redhat linux instance over openstack cloud. > > Database is around 441 GB. > > We are using below command to take backup: > > pg_basebackup -v -D /pgbackup/$bkupdir -Ft -z -c fast > > Backup size created is around 84GB. > > However, it is taking almost 10 hr 21 minutes to complete. > > Looking for speed improvement? pg_basebackup is single-threaded and the compression is pretty CPU-intensive. You could try reducing the compression level, but that will make the backups larger, of course. Also, there's a limit to how far that will get you- once you get to "no compression", that's just as fast as pg_basebackup can run. If you're interested in a backup tool which can operate in parallel, you might want to look at pgbackrest. Thanks! Stephen