pg_dump -j - Mailing list pgsql-admin

From Sam Stearns
Subject pg_dump -j
Date
Msg-id CAN6TVjmRACGXcz3XoiOKw3ws1tBs_bnwa3AD==vyxmEdUJ=z_g@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump -j
List pgsql-admin
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.

Thank you,

Sam

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com


pgsql-admin by date:

Previous
From: Joseph Craig
Date:
Subject: Postgres HA Deployment Questions
Next
From: "MichaelDBA@sqlexec.com"
Date:
Subject: Re: Postgres HA Deployment Questions