Postgres Pro
Downloads
Home   >   mailing lists

Aw: Re: How long does iteration over 4-5 million rows usually take? - Mailing list pgsql-general

From Karsten Hilbert
Subject Aw: Re: How long does iteration over 4-5 million rows usually take?
Date
Msg-id trinity-3d817328-9ee8-4c97-a95c-99c034f30558-1648907215445@3c-app-gmx-bap24
Whole thread Raw
In response to Re: How long does iteration over 4-5 million rows usually take?  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Re: How long does iteration over 4-5 million rows usually take?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view 
> > On Apr 1, 2022, at 10:18 PM, Ron <ronljohnsonjr@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)

I may not take quite that long because setup/teardown times might not be needed for each iteration.

Best,
Karsten

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: How long does iteration over 4-5 million rows usually take?
Next
From: Shaozhong SHI
Date:
Subject: Re: Re: How long does iteration over 4-5 million rows usually take?