> > On Apr 1, 2022, at 10:18 PM, Ron <ronljohnsonjr@xxxxxxxxx> 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