Postgres Pro
Downloads
Home   >   mailing lists

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

From Luca Ferrari
Subject Re: Regarding db dump with Fc taking very long time to completion
Date
Msg-id CAKoxK+6c9HmR5TOCnVS6RaGQduZsPhb37fsbRLJ5EtHNB6QAjg@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>)
Responses Re: Regarding db dump with Fc taking very long time to completion
List pgsql-general
Tree view 
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 partiton
onthat 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

pgsql-general by date:

Previous
From: Vicente Juan Tomas Monserrat
Date:
Subject: connection timeout with psycopg2
Next
From: Durgamahesh Manne
Date:
Subject: Re: Regarding db dump with Fc taking very long time to completion