Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding db dump with Fc taking very long time to completion - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: Regarding db dump with Fc taking very long time to completion
Date
Msg-id CAJCZkoJ_7+HBKLY3FfyhWnu0my1K98=e4CTZKoc8b4cc809pHA@mail.gmail.com
Whole thread Raw
In response to Re: Regarding db dump with Fc taking very long time to completion  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Tree view


On Wed, Oct 16, 2019 at 3:22 PM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:


On Wed, Oct 16, 2019 at 3:09 PM Luca Ferrari <fluca1978@gmail.com> wrote:
On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne
<maheshpostgres9@gmail.com> wrote:
>  Is there any way to reduce dump time when i take dump of the table which has 148gb in size without creating partition* on that table has 148gb in size ?

I would at least try a parallel dump: should it be -j option to pg_dump.
I'm not sure it is an effective parallelism against a single table.

Luca

Hi

parallel jobs with pg_dump can* be effective for the database which contains lot of tables&its dependent objects 

parallel jobs with pg_dump can not be effective against a single table 


Regards
Durgamahesh Manne

  

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Re: Regarding db dump with Fc taking very long time to completion
Next
From: M Tarkeshwar Rao
Date:
Subject: Is there any configuration in postgresql.conf or any otherconfiguration of postgres which will make this possible to listen onparticular interface