Postgres Pro
Downloads
Home   >   mailing lists

Re: How long does iteration over 4-5 million rows usually take? - Mailing list pgsql-sql

From Steve Midgley
Subject Re: How long does iteration over 4-5 million rows usually take?
Date
Msg-id CAJexoSJ5AjwXzxErAL93D+TLHT2EewtS9bk4iokHao9opa6XCw@mail.gmail.com
Whole thread Raw
In response to How long does iteration over 4-5 million rows usually take?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view


On Fri, Apr 1, 2022 at 6:35 PM Shaozhong SHI <shishaozhong@gmail.com> 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?


Please share the SQL query, schema, and sample data. If you are using a third party script with a db connector, then the answer is much harder to answer. 

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: How long does iteration over 4-5 million rows usually take?
Next
From: Shaozhong SHI
Date:
Subject: How to just get the last in a recursive query