public inbox for [email protected]
help / color / mirror / Atom feedFrom: CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG <[email protected]>
To: [email protected]
Subject: Re: pg_dump -j
Date: Thu, 13 Nov 2025 09:28:15 +0100
Message-ID: <922b1f47-ca95-e565-e8a1-1859a472bfa0@developpement-durable.gouv.fr> (raw)
In-Reply-To: <CANzqJaCfOQBa06TfkAs63dbnLRegOtOdDumKdn2S101KkiFrVA@mail.gmail.com>
References: <CAN6TVjmRACGXcz3XoiOKw3ws1tBs_bnwa3AD==vyxmEdUJ=z_g@mail.gmail.com>
<CANzqJaCfOQBa06TfkAs63dbnLRegOtOdDumKdn2S101KkiFrVA@mail.gmail.com>
<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:[email protected]">[email protected]</a>) a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CANzqJaCfOQBa06TfkAs63dbnLRegOtOdDumKdn2S101KkiFrVA@mail.gmail.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:[email protected]" moz-do-not-send="true">[email protected]</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>
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_dump -j
In-Reply-To: <922b1f47-ca95-e565-e8a1-1859a472bfa0@developpement-durable.gouv.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox