On Wed, Oct 16, 2019 at 3:22 PM Durgamahesh Manne <maheshpostgr...@gmail.com> wrote:
> > > On Wed, Oct 16, 2019 at 3:09 PM Luca Ferrari <fluca1...@gmail.com> wrote: > >> On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne >> <maheshpostgr...@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 > > >
