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

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Re: How long does iteration over 4-5 million rows usually take?
Дата
Msg-id CAJexoSJ5AjwXzxErAL93D+TLHT2EewtS9bk4iokHao9opa6XCw@mail.gmail.com
обсуждение исходный текст
Ответ на How long does iteration over 4-5 million rows usually take?  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-sql
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: How long does iteration over 4-5 million rows usually take?
Следующее
От: Shaozhong SHI
Дата:
Сообщение: How to just get the last in a recursive query