Re: pg_basebackup running slow

From: Samir Magar <samirmagar8(at)gmail(dot)com>
To: Swapnil Vaze <swapvaze28(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_basebackup running slow
Date: 2016-10-14 13:21:46
Message-ID: CAA=to3j4YWPh0xg0Y7C9s8ak5=3HwkGWDSTGNi-tHFYxW04Z0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Paquier 2016-10-14 13:37:11 Re: pg_basebackup running slow
Previous Message Swapnil Vaze 2016-10-14 12:35:01 pg_basebackup running slow