Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.
Date: 2018-10-11 03:14:08
Message-ID: CAEHH7R6MCKpyjnU9-RAnznkfqQ8=C7pgfd8hO8SVm3p6zJ7gng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are using postgresql 9.2. It doesn't contain the option.

Please guide me any other approaches to improve the performance of pg_dump.

On Thu 11 Oct, 2018, 8:05 AM Pavan Teja, <pavan(dot)postgresdba(at)gmail(dot)com>
wrote:

> Hi,
>
> You can use -j jobs option to speed up the process.
>
> Hope it works.
>
> Regards,
> Pavan
>
> On Thu, Oct 11, 2018, 8:02 AM Raghavendra Rao J S V <
> raghavendrajsv(at)gmail(dot)com> wrote:
>
>> Hi All,
>>
>> pg_dump is taking more time. Please let me know which configuration
>> setting we need to modify to speedup the pg_dump backup.We are using 9.2
>> version on Centos Box.
>>
>> --
>> Regards,
>> Raghavendra Rao J S V
>>
>>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-10-11 03:16:13 Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.
Previous Message Christopher Browne 2018-10-11 03:11:01 Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.