Request a Demo
Home   >   mailing lists

Re: pg_dump -j - Mailing list pgsql-admin

From Ron Johnson
Subject Re: pg_dump -j
Date
Msg-id CANzqJaCfOQBa06TfkAs63dbnLRegOtOdDumKdn2S101KkiFrVA@mail.gmail.com
Whole thread Raw
In response to pg_dump -j  (Sam Stearns <sam.stearns@dat.com>)
List pgsql-admin
Tree view
On Wed, Nov 12, 2025 at 10:34 AM Sam Stearns <sam.stearns@dat.com> wrote:
Howdy,

Would someone be able to advise on the correct setting for the -j option of pg_dump to run the dump in parallel, please?  Is it based on CPU count, or something else?  The output of nproc is 32.

I'd certainly never go beyond $(nproc), but since COPY generates a lot of IO and compression burns through CPU, it all depends on the system's other workload.  Only you know what your system's other workload is when pg_dump is running.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Peter Gram
Date:
Subject: Re: Postgres HA Deployment Questions
Next
From: Sbob
Date:
Subject: vacuum process running for more than 2 days, still in scanning heap phase