Обсуждение: How long does iteration over 4-5 million rows usually take?

Поиск
Список
Период
Сортировка

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

От
Shaozhong SHI
Дата:


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?

От
Steve Midgley
Дата:


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.