Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_basebackup running slow - Mailing list pgsql-performance

From Samir Magar
Subject Re: pg_basebackup running slow
Date
Msg-id CAA=to3j4YWPh0xg0Y7C9s8ak5=3HwkGWDSTGNi-tHFYxW04Z0g@mail.gmail.com
Whole thread Raw
In response to pg_basebackup running slow  (Swapnil Vaze <swapvaze28@gmail.com>)
Responses Re: pg_basebackup running slow  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-performance
Tree view
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


pgsql-performance by date:

Previous
From: Swapnil Vaze
Date:
Subject: pg_basebackup running slow
Next
From: Michael Paquier
Date:
Subject: Re: pg_basebackup running slow