Re: pg_basebackup running slow

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Samir Magar <samirmagar8(at)gmail(dot)com>
Cc: Swapnil Vaze <swapvaze28(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: Re: pg_basebackup running slow
Date: 2016-10-14 13:37:11
Message-ID: CAB7nPqQA9-1TBHeYHk_5gnktSBn07U_5QrtSLdMrc58WSZD=Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 14, 2016 at 10:21 PM, Samir Magar <samirmagar8(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Frost 2016-10-14 13:37:51 Re: pg_basebackup running slow
Previous Message Samir Magar 2016-10-14 13:21:46 Re: pg_basebackup running slow