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

[Rob Sargent]

> On Apr 1, 2022, at 10:18 PM, Ron <ronljohnso...@gmail.com> wrote:
> 
>  On 4/1/22 20: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?

4-5 million times as long as it takes to do one iteration ( if you’re doing it 
correctly)