MIME-Version: 1.0
References: 
 <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 2 Apr 2022 02:34:26 +0100
Message-ID: 
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
Subject: How long does iteration over 4-5 million rows usually take?
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dfc8b305dba1e5bb"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA%40mail.gmail.com>
Precedence: bulk

--000000000000dfc8b305dba1e5bb
Content-Type: text/plain; charset="UTF-8"

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?

Regards,

David

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><br><div dir=3D"ltr"><div dir=
=3D"ltr">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.<div><br></div=
><div>How long does iteration over 4-5 million rows usually take?</div><div=
><br></div><div>Regards,</div><div><br></div><div>David</div></div></div>
</div></div>

--000000000000dfc8b305dba1e5bb--