MIME-Version: 1.0
From: Sam Stearns <sam.stearns@dat.com>
Date: Wed, 12 Nov 2025 07:33:48 -0800
Message-ID: 
 <CAN6TVjmRACGXcz3XoiOKw3ws1tBs_bnwa3AD==vyxmEdUJ=z_g@mail.gmail.com>
Subject: pg_dump -j
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Henry Ashu <henry.ashu@dat.com>, Avi Vallarapu <av@hexacluster.ai>
Content-Type: multipart/alternative; boundary="0000000000004864930643677e24"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN6TVjmRACGXcz3XoiOKw3ws1tBs_bnwa3AD%3D%3DvyxmEdUJ%3Dz_g%40mail.gmail.com>
Precedence: bulk

--0000000000004864930643677e24
Content-Type: text/plain; charset="UTF-8"

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

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>

--0000000000004864930643677e24
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Howdy,</div><div><br></div><div>Would someone be able=
 to advise on the correct setting for the -j option of pg_dump to run the d=
ump in parallel, please?=C2=A0 Is it based on CPU count, or something else?=
=C2=A0 The output of nproc is 32.</div><div><br></div><div>Thank you,</div>=
<div><br></div><div>Sam</div><div><br></div><span class=3D"gmail_signature_=
prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr"><span><p dir=3D"ltr" style=3D"lin=
e-height:1.38;margin-top:10pt;margin-bottom:10pt"><span style=3D"font-size:=
11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);background-color:tran=
sparent;font-weight:700;vertical-align:baseline">Samuel Stearns</span><span=
 style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);b=
ackground-color:transparent;font-weight:700;vertical-align:baseline"><br></=
span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;color:rgb(1=
02,102,102);background-color:transparent;vertical-align:baseline">Team Lead=
 - Database</span><span style=3D"font-size:11pt;font-family:Inter,sans-seri=
f;color:rgb(102,102,102);background-color:transparent;vertical-align:baseli=
ne"><br></span><span style=3D"font-size:11pt;font-family:Inter,sans-serif;c=
olor:rgb(102,102,102);background-color:transparent;vertical-align:baseline"=
>c: 971 762 6879 </span><span style=3D"font-size:11pt;font-family:Inter,san=
s-serif;color:rgb(147,149,152);background-color:transparent;vertical-align:=
baseline">|</span><span style=3D"font-size:11pt;font-family:Inter,sans-seri=
f;color:rgb(102,102,102);background-color:transparent;vertical-align:baseli=
ne"> o: 971 762 6879 </span><span style=3D"font-size:11pt;font-family:Inter=
,sans-serif;color:rgb(147,149,152);background-color:transparent;vertical-al=
ign:baseline">|</span><span style=3D"font-size:11pt;font-family:Inter,sans-=
serif;color:rgb(102,102,102);background-color:transparent;vertical-align:ba=
seline"> DAT.com</span></p><p dir=3D"ltr" style=3D"line-height:1.38;margin-=
top:0pt;margin-bottom:0pt"><a href=3D"https://www.dat.com/?utm_medium=3Dema=
il&amp;utm_source=3DDAT_email_signature_link" target=3D"_blank"><span style=
=3D"font-size:11pt;font-family:Arial,sans-serif;color:rgb(17,85,204);backgr=
ound-color:transparent;vertical-align:baseline"><span style=3D"border:none;=
display:inline-block;overflow:hidden;width:126px;height:54px"><img src=3D"h=
ttps://lh7-rt.googleusercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOk=
HWIArmSrehhAl-cXaYxECakbMV5owUfMaMjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5i=
T2P2eOJu4jtqizp_fYM0Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt?key=3Dz3dM0-Cr9WzKyLau=
PVBgWw" width=3D"126" height=3D"54" style=3D"margin-left:0px;margin-top:0px=
"></span></span></a></p><div><br></div></span></div></div></div>

--0000000000004864930643677e24--