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 ) id 1nae5p-0002Ve-QL for pgsql-general@arkaria.postgresql.org; Sat, 02 Apr 2022 13:47:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nae5o-0006VD-DN for pgsql-general@arkaria.postgresql.org; Sat, 02 Apr 2022 13:47:04 +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 ) id 1nae5o-0006V3-1s for pgsql-general@lists.postgresql.org; Sat, 02 Apr 2022 13:47:04 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nae5j-0001rG-1x for pgsql-general@lists.postgresql.org; Sat, 02 Apr 2022 13:47:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1648907215; bh=znG21GGmjqxGKFdc+U+zpo+HKNdPYzE8mCSyasU7ZmA=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=XtnUZlPB7KKlqQzxmorzEYPfxLKADHrnM7Ay7l9HINdTQOQNy76o881l6IDFz9mf1 ygjIgQNEinFG8b+RremGkmwGRYveS2zXeseNJZ5vg/hTRukX6+3qK+aedeW7X4G5Be 6TdIGm91dD/7OkVkxxZ8nJRKvQhhNpV+UDP3mkqc= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [217.91.207.107] ([217.91.207.107]) by web-mail.gmx.net (3c-app-gmx-bap24.server.lan [172.19.172.94]) (via HTTP); Sat, 2 Apr 2022 15:46:55 +0200 MIME-Version: 1.0 Message-ID: From: Karsten Hilbert To: Rob Sargent Cc: Ron , pgsql-general@lists.postgresql.org Subject: Aw: Re: How long does iteration over 4-5 million rows usually take? Content-Type: text/plain; charset=UTF-8 Date: Sat, 2 Apr 2022 15:46:55 +0200 Importance: normal Sensitivity: Normal In-Reply-To: References: Content-Transfer-Encoding: quoted-printable X-UI-Message-Type: mail X-Priority: 3 X-Provags-ID: V03:K1:BhXefQce0IcMn7oyilrpwXn3jCbXxzH12oevgDAWz0qCF1GZQfHIxVahK45moQGpY+y6c HMmL1MesyKVI2srSJZO85n52jEigU7Inucfr840Xn4g+DhcT1lyYCzApfHibA/c0XRccvxysGx7M bIJDX2Fuy4QebbrDyr+IIpWNIgE9TS4XnqHC6tRueC7tZmJFDlMjo3apQJfllRWGaulIcMOlJCg0 sKXA4xJHfn54b0CMbTqjnPK2w5Oan7YCV8EOCZcBt9Wt8gO8Ccko+fRxdY49x17vdG1V8nQHB0hD 2w= X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:0HJ7xVES1so=:ikPcKH2hQi1QBgmhi4PYMF 1b8sOKHYq6x4Znyee9j17RHHaczbj0bNp6jQ9/jmMw8qhp/rIMcWHEIEc6TDU4ckn4ouHDqt6 wNgq9vp+Z5nwuMnV5PmYg2M/Ym2b8YFs3vmIwHIyOxYiwXNol13otjWcWGI+8UcMUwx8E0411 kZ0RkxgEogMpqSmjy5mp0cGrx7m+xi1yO/v3lvqUO+ApknvGDe+lPQOPkxE7SqzYunZgqwks/ UrpRglPAtKrM3nSfk64Lya6P4w37ptJHwykwMf9yYGXLLVwdA0CwAIT3/VGVkgqGrCjVPwwjf hGt1IX4/68UUXYLSwGSS2SsKUckrqgnn3ou0HzHxyccv0Kz8scOWsuEde3rPgEuz5NhFlC74w uN3ITV1TdB62hgMLFvsn1t97d+RnJeqUvadiqjxhsrAkY3zkrNiJ6yCPnJS4Bt2RiMSAhFvup zhSuCRyOse0basEthpzq/aGuDLzjaHq+Fv3Cp6dDy6OjPVr1QWPZYfK16A8SCPuAbGKFdwKXO rFIPIxHyIFnw1KSYn3cOHCLAPHKiKO/vgfRt5OMfL8ndIW7cPIhxX/wYTKZ5CNhQUX1H32DWX qicCuTSxgH3+RkjZ+ratUa3LyM/N3BmVNxSBcRbBWVXjfIH7w+cUfvZv8omUQJPUpVzI6a94X VH8AKyU+qrA4f2m46VdkfLW+CVSG1WvZrPoC4aGv6BiKETgT3PEepTgwQRyew4juNJY2RYHyM KUL3HAyNf4HpCAtyjaM6bVcajS0F0g2gPqOi2ekdKsqKaxbmD8LRspXr9sA5XfmHNBMMXW/rR XhN15H7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > On Apr 1, 2022, at 10:18 PM, Ron wrote: > >=20 > > =EF=BB=BF On 4/1/22 20:34, Shaozhong SHI wrote: > >>=20 > >> I have a script running to iterate over 4-5 million rows=2E It keeps= showing up in red in PgAdmin=2E It remains active=2E > >>=20 > >> How long does iteration over 4-5 million rows usually take? >=20 > 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 n= eeded for each iteration=2E Best, Karsten