| 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:53:13 |
| Message-ID: | CAJCZkoJ_7+HBKLY3FfyhWnu0my1K98=e4CTZKoc8b4cc809pHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 16, 2019 at 3:22 PM Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
wrote:
>
>
> 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 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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M Tarkeshwar Rao | 2019-10-16 10:07:33 | Is there any configuration in postgresql.conf or any other configuration of postgres which will make this possible to listen on particular interface |
| Previous Message | Durgamahesh Manne | 2019-10-16 09:52:15 | Re: Regarding db dump with Fc taking very long time to completion |