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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How long does iteration over 4-5 million rows usually take?
Date: 2022-04-02 01:47:42
Message-ID: 3ad78742-7ce3-f2cd-e7c4-84a6e8e30ae5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On 4/1/22 18:34, Shaozhong SHI 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?

Given that there is no real information provided in the problem
description there is no chance for an answer more detailed then; as long
as it takes.

>
> Regards,
>
> David

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-04-02 02:18:45 Re: How long does iteration over 4-5 million rows usually take?
Previous Message Shaozhong SHI 2022-04-02 01:35:04 How long does iteration over 4-5 million rows usually take?

Browse pgsql-sql by date

  From Date Subject
Next Message Ron 2022-04-02 02:18:45 Re: How long does iteration over 4-5 million rows usually take?
Previous Message Shaozhong SHI 2022-04-02 01:35:04 How long does iteration over 4-5 million rows usually take?