| From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
|---|---|
| To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regarding db dump with Fc taking very long time to completion |
| Date: | 2019-10-16 09:52:15 |
| Message-ID: | CAJCZkoJWKDeVMdMti8YKr1Sh+9-YNBV5V0Luo7NoqHvRsxaVpQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 16, 2019 at 3:09 PM Luca Ferrari <fluca1978(at)gmail(dot)com> wrote:
> On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne
> <maheshpostgres9(at)gmail(dot)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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durgamahesh Manne | 2019-10-16 09:53:13 | Re: Regarding db dump with Fc taking very long time to completion |
| Previous Message | Luca Ferrari | 2019-10-16 09:38:53 | Re: Regarding db dump with Fc taking very long time to completion |