MIME-Version: 1.0
References: <bb7eeb84-5c47-169c-9353-d504436c2060@gmail.com>
 <D5A56FC9-C99B-40E8-86FC-4F572EA74149@gmail.com>
 <trinity-3d817328-9ee8-4c97-a95c-99c034f30558-1648907215445@3c-app-gmx-bap24>
In-Reply-To: 
 <trinity-3d817328-9ee8-4c97-a95c-99c034f30558-1648907215445@3c-app-gmx-bap24>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 2 Apr 2022 15:16:14 +0100
Message-ID: 
 <CA+i5JwaUOJ+r6H+3VfNaoZXTykAyhpy8q8j5JjHw-=_AWTtLfQ@mail.gmail.com>
Subject: Re: Re: How long does iteration over 4-5 million rows usually take?
To: Karsten Hilbert <Karsten.Hilbert@gmx.net>
Cc: Rob Sargent <robjsargent@gmail.com>, Ron <ronljohnsonjr@gmail.com>,
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000568d4505dbac8a1f"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwaUOJ%2Br6H%2B3VfNaoZXTykAyhpy8q8j5JjHw-%3D_AWTtLfQ%40mail.gmail.com>
Precedence: bulk

--000000000000568d4505dbac8a1f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks, Karsten,

I would like the information to work planning purpose.

Regards,

David

On Sat, 2 Apr 2022 at 14:47, Karsten Hilbert <Karsten.Hilbert@gmx.net>
wrote:

> > > On Apr 1, 2022, at 10:18 PM, Ron <ronljohnsonjr@gmail.com> wrote:
> > >
> > > =EF=BB=BF On 4/1/22 20:34, Shaozhong SHI wrote:
> > >>
> > >> I have a script running to iterate over 4-5 million rows.  It keeps
> showing up in red in PgAdmin.  It remains active.
> > >>
> > >> How long does iteration over 4-5 million rows usually take?
> >
> > 4-5 million times as long as it takes to do one iteration ( if you=E2=
=80=99re
> doing it correctly)
>
> I may not take quite that long because setup/teardown times might not be
> needed for each iteration.
>
> Best,
> Karsten
>
>
>

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

<div dir=3D"ltr">Thanks, Karsten,<div><br></div><div>I would like the infor=
mation to work planning purpose.</div><div><br></div><div>Regards,</div><di=
v><br></div><div>David</div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Sat, 2 Apr 2022 at 14:47, Karsten Hilbert =
&lt;<a href=3D"mailto:Karsten.Hilbert@gmx.net">Karsten.Hilbert@gmx.net</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">&gt; =
&gt; On Apr 1, 2022, at 10:18 PM, Ron &lt;<a href=3D"mailto:ronljohnsonjr@g=
mail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br>
&gt; &gt; <br>
&gt; &gt; =EF=BB=BF On 4/1/22 20:34, Shaozhong SHI wrote:<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; I have a script running to iterate over 4-5 million rows.=C2=
=A0 It keeps showing up in red in PgAdmin.=C2=A0 It remains active.<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; How long does iteration over 4-5 million rows usually take?<b=
r>
&gt; <br>
&gt; 4-5 million times as long as it takes to do one iteration ( if you=E2=
=80=99re doing it correctly)<br>
<br>
I may not take quite that long because setup/teardown times might not be ne=
eded for each iteration.<br>
<br>
Best,<br>
Karsten<br>
<br>
<br>
</blockquote></div>

--000000000000568d4505dbac8a1f--