Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1naSfg-0007UQ-Lp
	for pgsql-sql@arkaria.postgresql.org; Sat, 02 Apr 2022 01:35:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1naSff-0007E4-Ie
	for pgsql-sql@arkaria.postgresql.org; Sat, 02 Apr 2022 01:35:19 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <shishaozhong@gmail.com>)
	id 1naSff-0007Dv-9i
	for pgsql-sql@lists.postgresql.org; Sat, 02 Apr 2022 01:35:19 +0000
Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <shishaozhong@gmail.com>)
	id 1naSfd-0004SP-2U
	for pgsql-sql@lists.postgresql.org; Sat, 02 Apr 2022 01:35:18 +0000
Received: by mail-ej1-x631.google.com with SMTP id pv16so9409058ejb.0
        for <pgsql-sql@lists.postgresql.org>;
 Fri, 01 Apr 2022 18:35:16 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to;
        bh=zU0GTXuSMc8/4uZ/q/U2ZyW9397XFLplp3ZWblzWij8=;
        b=IAtG27qSDZItJJdU70u7LzVzgl5E+COLh8SHx/YXjuIbgSbQWQXuvU13k9BsbwjKTG
         +OoHl01qcugyeszTQNjjUqFcYXsgYHGNKj2mwm9AjRWFvCqTGhoxlIwOD94h83Q8FnoI
         YwsjEB7vu2nCbtwCPMO15ABHMQFvj3zDtYJ1iYqIGzGOpa1IRIzf89+uirtNeQsNMHtk
         79wwtMN7Qpp7arSMWOzAz81BzEILUKOmpVhc0smlFCx2VwvANeLOAvOW+nYgGrBwM7Aq
         IacgaY+/EqmSk888q/1VerOd1IJFWSIIt0rIVgS8Z8rwc74GcfDUIowoQKtTM+6sb11I
         v/Jw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to;
        bh=zU0GTXuSMc8/4uZ/q/U2ZyW9397XFLplp3ZWblzWij8=;
        b=6ESXb6yG8A5RAqntE53ns2BLz7SQBX4HtrpuD8LZf0Ejc0OTfnipoL+0B+7RLZQs3G
         +GoJ6QsYU3MHhaO+umEscK77W9Hjh6lJ55Ok0Lf4DJCVfoQsxD6VQ/2J84pSx5iYaO7H
         GbXiurzUmJ86867qB9IrlMZbDOQOmKjwAPQlWf1Zw3EG81kyyEGhSuA6MkzieChhTiFm
         Tqu28Ob+6ENq4LJg7S86AFna+2erqvYfZjr1NmBPhe6o4U6I29Sqp3GIQEI+1RHfCai3
         T1/Oz1KbNhsAZF/bACis9XaDvSu/0tRAA0xEH3nTEW0eXRM1pLclC/exrYg6vm/VOQWS
         PRIA==
X-Gm-Message-State: AOAM531mOlsCDiVGTrveZNXqvsHMDip+SomOyphIRlzx4twSISKmjoo1
	53rnpTPrXZaqMkcgdemhTwjcncn3x8c1falf8uFD/XCl
X-Google-Smtp-Source: 
 ABdhPJw3mnArOkMD27T+WdX5UOFrANiaNTTOOnuGbex16f2LMqUx0viF/q7OFvcWdlT6K3bwcFcXf8oTwQuqjl2VnmE=
X-Received: by 2002:a17:907:6d1b:b0:6e6:2583:cea5 with SMTP id
 sa27-20020a1709076d1b00b006e62583cea5mr956963ejc.188.1648863314958; Fri, 01
 Apr 2022 18:35:14 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 2 Apr 2022 02:35:04 +0100
Message-ID: 
 <CA+i5JwaNx645eZM0MWh=phhsY9KZem8af6f8pEMRgDqrG5W2kQ@mail.gmail.com>
Subject: How long does iteration over 4-5 million rows usually take?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002bdeb605dba1e819"
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwaNx645eZM0MWh%3DphhsY9KZem8af6f8pEMRgDqrG5W2kQ%40mail.gmail.com>
Precedence: bulk

--0000000000002bdeb605dba1e819
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

--0000000000002bdeb605dba1e819
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 class=
=3D"gmail_quote"><br><div dir=3D"ltr"><div dir=3D"ltr">I have a script runn=
ing to iterate over 4-5 million rows.=C2=A0 It keeps showing up in red in P=
gAdmin.=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>
</div></div>

--0000000000002bdeb605dba1e819--