<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,<br>
</p>
<p>Processeurs is on of the parameters . An other is the
outpout:input capacity to write on disks.<br>
</p>
<p>I purpose to test your hardware performance with 12 jobs to begin
and test less and high to learn which is better.<br>
</p>
<p>You can found it approximately with the rate of your speeding
writing ratio on disk or outpout of LAN card factoring by job's
number.<br>
</p>
<p>But testing IRL is more efficient.<br>
</p>
<p>We use 7 jobs for à 16 nprocs on saving on a master save dedicate
to with car LAN 1000GhZ for example.<br>
</p>
<p>We do it online but without clients traffic and without
maintenance operation.<br>
</p>
<p>Tell us wich is your better choice!<br>
</p>
<p>Bye<br>
</p>
<p>Yann<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Le 12/11/2025 à 17:11, >
ronljohnsonjr (par Internet, dépôt
<a class="moz-txt-link-abbreviated" href="mailto:pgsql-admin-owner+m63745-708218(at)lists(dot)postgresql(dot)org">pgsql-admin-owner+m63745-708218(at)lists(dot)postgresql(dot)org</a>) a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CANzqJaCfOQBa06TfkAs63dbnLRegOtOdDumKdn2S101KkiFrVA(at)mail(dot)gmail(dot)com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">On Wed, Nov 12, 2025 at 10:34 AM Sam Stearns <<a
href="mailto:sam(dot)stearns(at)dat(dot)com" moz-do-not-send="true">sam(dot)stearns(at)dat(dot)com</a>>
wrote:</div>
<div class="gmail_quote gmail_quote_container">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="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 dump in
parallel, please? Is it based on CPU count, or
something else? The output of nproc is 32.</div>
</div>
</blockquote>
</div>
<div><br>
</div>
<div>I'd certainly never go <i>beyond</i> $(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.</div>
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">Death to <Redacted>, and butter sauce.
<div>Don't boil me, I'm still alive.<br>
<div>
<div><Redacted> lobster!</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>