Postgres Pro
Downloads
Home   >   mailing lists

Re: Please let me know which configuration setting we need to modifyto speedup the pg_dump backup. - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject Re: Please let me know which configuration setting we need to modifyto speedup the pg_dump backup.
Date
Msg-id CAEHH7R6MCKpyjnU9-RAnznkfqQ8=C7pgfd8hO8SVm3p6zJ7gng@mail.gmail.com
Whole thread Raw
In response to Re: Please let me know which configuration setting we need to modifyto speedup the pg_dump backup.  (Pavan Teja <pavan.postgresdba@gmail.com>)
Responses Re: Please let me know which configuration setting we need tomodify to speedup the pg_dump backup.
List pgsql-general
Tree view
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.postgresdba@gmail.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@gmail.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

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Please let me know which configuration setting we need to modifyto speedup the pg_dump backup.
Next
From: Raghavendra Rao J S V
Date:
Subject: Re: Please let me know which configuration setting we need to modifyto speedup the pg_dump backup.