MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sun, 10 Apr 2022 14:50:32 +0100
Message-ID: 
 <CA+i5JwYMZ_eUtbdGBX9vg2GQzpTLo9m+bMoW1wniEqVv5sxV-w@mail.gmail.com>
Subject: How best to do parallel query given tens of thousands of iteration of
 a loop of recursive queries?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000230ad405dc4d1d53"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwYMZ_eUtbdGBX9vg2GQzpTLo9m%2BbMoW1wniEqVv5sxV-w%40mail.gmail.com>
Precedence: bulk

--000000000000230ad405dc4d1d53
Content-Type: text/plain; charset="UTF-8"

There is a plpgsql script that have a loop to carry out the same recursive
queries.

The estimation of iteration is in the order of tens of thousands.

What is the best way of making using parallel query strategy.

Any examples?

Regards,

David

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

<div dir=3D"ltr">There is a plpgsql script that have a loop to carry out th=
e same recursive queries.<div><br></div><div>The estimation of iteration is=
 in the order of tens of thousands.</div><div><br></div><div>What is the be=
st way of making using parallel query strategy.</div><div><br></div><div>An=
y examples?</div><div><br></div><div>Regards,</div><div><br></div><div>Davi=
d</div></div>

--000000000000230ad405dc4d1d53--