Postgres Pro
Downloads
Home   >   mailing lists

Thread: How long does iteration over 4-5 million rows usually take?

How long does iteration over 4-5 million rows usually take?

From
Shaozhong SHI
Date:


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

Re: How long does iteration over 4-5 million rows usually take?

From
Steve Midgley
Date:


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.