Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



For work planning, create a temporary table, copy from a generated data set, and test it out. It really depends. Normally, you don't iterate in SQL since rows are assumed to be independent. You think about SQL in terms of sets and let application code handle the data transfers. It also really depends on the size of your tables, indexing, joins, and more. Basically, there isn't really an answer but it isnt hard to test.

Thanks,
Ben


On Sat, Apr 2, 2022, 10:16 AM Shaozhong SHI <shishaozhong@xxxxxxxxx> wrote:
Thanks, Karsten,

I would like the information to work planning purpose.

Regards,

David

On Sat, 2 Apr 2022 at 14:47, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote:
> > 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux