Thanks, Karsten, I would like the information to work planning purpose.
Regards, David On Sat, 2 Apr 2022 at 14:47, Karsten Hilbert <karsten.hilb...@gmx.net> wrote: > > > 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) > > I may not take quite that long because setup/teardown times might not be > needed for each iteration. > > Best, > Karsten > > >