Re: pg_basebackup running slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux