| From: | Steve Midgley <science(at)misuse(dot)org> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How long does iteration over 4-5 million rows usually take? |
| Date: | 2022-04-02 16:38:41 |
| Message-ID: | CAJexoSJ5AjwXzxErAL93D+TLHT2EewtS9bk4iokHao9opa6XCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Fri, Apr 1, 2022 at 6:35 PM Shaozhong SHI <shishaozhong(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Scott | 2022-04-02 19:09:15 | Re: weird issue with occasional stuck queries |
| Previous Message | Benedict Holland | 2022-04-02 14:34:34 | Re: Re: How long does iteration over 4-5 million rows usually take? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2022-04-04 22:14:22 | How to just get the last in a recursive query |
| Previous Message | Benedict Holland | 2022-04-02 14:34:34 | Re: Re: How long does iteration over 4-5 million rows usually take? |