MIME-Version: 1.0
In-Reply-To: 
 <CAJSrDUoBN0KGdBdQKD_tjUFM2LJipefJuQ5GpQrY2iFm8Y2J3Q@mail.gmail.com>
References: 
 <CAJSrDUoBN0KGdBdQKD_tjUFM2LJipefJuQ5GpQrY2iFm8Y2J3Q@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 8 Dec 2024 08:26:43 -0700
Message-ID: 
 <CAKFQuwbkVaAHT+nBfwffZY89pWvqtkK4q0aOmX9PT3Hf7oz2sA@mail.gmail.com>
Subject: Re: What is the best way to do this in Postgres
To: kunwar singh <krishsingh.111@gmail.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000212e850628c3e053"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbkVaAHT%2BnBfwffZY89pWvqtkK4q0aOmX9PT3Hf7oz2sA%40mail.gmail.com>
Precedence: bulk

--000000000000212e850628c3e053
Content-Type: text/plain; charset="UTF-8"

On Sunday, December 8, 2024, kunwar singh <krishsingh.111@gmail.com> wrote:

>
> I know I can create a bash script or Python script , but I am wondering if
> there is a smarter way to do it in Postgres?
>
>
Your concurrency requirement makes doing it in the server quite difficult.
Using anything that can launch multiple processes/threads and initiate one
connect each is your best option.  Many things can, so pick one you are
familiar with.  There is little complexity here that specialized tooling
would be needed for.

David J.

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

On Sunday, December 8, 2024, kunwar singh &lt;<a href=3D"mailto:krishsingh.=
111@gmail.com">krishsingh.111@gmail.com</a>&gt; wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><div><br></div><div><div style=3D"font-famil=
y:Menlo,Monaco,&quot;Courier New&quot;,monospace;font-size:12px;line-height=
:18px;white-space:pre-wrap"><div><font style=3D"background-color:rgb(243,24=
3,243)" color=3D"#0000ff">I know I can create a bash script or Python scrip=
t , but I am wondering if there is a smarter way to do it in Postgres?</fon=
t></div></div></div><br></div></blockquote><div><br></div><div>Your concurr=
ency requirement makes doing it in the server quite difficult.=C2=A0 Using =
anything that can launch multiple processes/threads and initiate one connec=
t each is your best option.=C2=A0 Many things can, so pick one you are fami=
liar with.=C2=A0 There is little complexity here that specialized tooling w=
ould be needed for.</div><div><br></div><div>David J.=C2=A0<br></div>

--000000000000212e850628c3e053--