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 1nadgm-0000ch-Sg for pgsql-general@arkaria.postgresql.org; Sat, 02 Apr 2022 13:21:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nadgk-0008E8-UF for pgsql-general@arkaria.postgresql.org; Sat, 02 Apr 2022 13:21:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nadgk-0008Dy-Gx for pgsql-general@lists.postgresql.org; Sat, 02 Apr 2022 13:21:10 +0000 Received: from mail-qk1-x72e.google.com ([2607:f8b0:4864:20::72e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nadgf-0003r1-1K for pgsql-general@lists.postgresql.org; Sat, 02 Apr 2022 13:21:09 +0000 Received: by mail-qk1-x72e.google.com with SMTP id 1so4209488qke.1 for ; Sat, 02 Apr 2022 06:21:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=sbsFnS/sAWyjoETHPAemvoRxWtXcoNMKK4c7mO6ZSUY=; b=HccbLEbdIi1sBUlgvdRu2Fs0tmI8LdMuu9cZEf+D5JpeCQt15uZx0DgtAbktJpZ83b QXRqze9KYnUX8DkY231s2BYtckGnqv4TiivvFPFNEDzhSf/Qbdc3GRSpYeP3u8tKm66m 7yU9QHWC3tu1nsjZJAz0LKTSZl4UMR0P+dY8w+eGLzlN67tFOA1wvr9zanhMEFVW4qBQ aHhp1GVZVU06WgB+ZlzXMLAG2BhuU2YHF4tOhp/+/EiRh+L4YvkKtljXJ17fpkWMgEwK 5SJRw9A9Gpkfbex0OaAmYgfYNT4XMtpQUga0HkPfOrj1qAS3YFmRGCTE+63m+EkQDSCc aaWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=sbsFnS/sAWyjoETHPAemvoRxWtXcoNMKK4c7mO6ZSUY=; b=pnNTcLpNVOhnx1kb5f+wlvVzNG6l2nxR5hIo+GWePg8PsiQ/aost6i0fhBamILeAY7 UxxOvQtwidqeCCij8WmElaT7DoL//sl0mgrYJ9ptBCv4QwVNKecAoaqHsLpS724hHjSi ccBq6pm1qNEyz/niLeWd0oEkrhn4Sza5i8D0QuaHGv/M9QSg4JRCUfL0tbvkr26jY/Wz TNH8mAmWrXggTMLgm1xkjyFdAFkl6IFJATUqvYqE0oDCLS1/cacqgjh8rSsSixUMWuJ1 nx+4VweBeUfAxAAZkyqKDxF5MW4mtDlnv4X9/k1MoaXlzeixwrFshq3xkw8ZuyAiJ/lY rRhA== X-Gm-Message-State: AOAM530/C+GshFxUYOcPsQy+YNrOpR/9f7wJ0N/fZbECDgQo26l/OwzL aifiZGX9S+XviVCO5+Dx4gorffolbl8= X-Google-Smtp-Source: ABdhPJxSTOCRKG2pj0Ln+yCRk2QoCG9ybYfryh8BDgScsPVbG9SF12p7zBYGHMe469kT51TDXdXHaw== X-Received: by 2002:a37:b983:0:b0:67e:c0d2:c3ca with SMTP id j125-20020a37b983000000b0067ec0d2c3camr9044181qkf.749.1648905662881; Sat, 02 Apr 2022 06:21:02 -0700 (PDT) Received: from smtpclient.apple ([2600:1005:b0b1:5bed:9861:911f:e5d9:7a4d]) by smtp.gmail.com with ESMTPSA id k2-20020a37ba02000000b0067dc1b0104asm2870372qkf.124.2022.04.02.06.21.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 02 Apr 2022 06:21:02 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: How long does iteration over 4-5 million rows usually take? Date: Sat, 2 Apr 2022 09:21:00 -0400 Message-Id: References: Cc: pgsql-general@lists.postgresql.org In-Reply-To: To: Ron X-Mailer: iPhone Mail (19D52) 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. It keeps showi= ng up in red in PgAdmin. It remains active. >>=20 >> 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=99r= e doing it correctly)