On Wed, Oct 16, 2019 at 11:27 AM Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote: > Is there any way to reduce dump time when i take dump of the table which has 148gb in size without creating partiton 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