public inbox for [email protected]
help / color / mirror / Atom feedFrom: Steve Midgley <[email protected]>
To: Shaozhong SHI <[email protected]>
Cc: pgsql-sql <[email protected]>
Subject: Re: How long does iteration over 4-5 million rows usually take?
Date: Sat, 2 Apr 2022 09:38:41 -0700
Message-ID: <CAJexoSJ5AjwXzxErAL93D+TLHT2EewtS9bk4iokHao9opa6XCw@mail.gmail.com> (raw)
In-Reply-To: <CA+i5JwaNx645eZM0MWh=phhsY9KZem8af6f8pEMRgDqrG5W2kQ@mail.gmail.com>
References: <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
<CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
<CA+i5JwaNx645eZM0MWh=phhsY9KZem8af6f8pEMRgDqrG5W2kQ@mail.gmail.com>
On Fri, Apr 1, 2022 at 6:35 PM Shaozhong SHI <[email protected]> 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?
>
>
Please share the SQL query, schema, and sample data. If you are using a
third party script with a db connector, then the answer is much harder to
answer.
view thread (9+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How long does iteration over 4-5 million rows usually take?
In-Reply-To: <CAJexoSJ5AjwXzxErAL93D+TLHT2EewtS9bk4iokHao9opa6XCw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox