Content-Type: multipart/alternative;
 boundary="------------w74ksSzKYQKyqWHPHUwzAaL0"
Message-ID: <bb7eeb84-5c47-169c-9353-d504436c2060@gmail.com>
Date: Fri, 1 Apr 2022 21:18:45 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: How long does iteration over 4-5 million rows usually take?
Content-Language: en-US
To: pgsql-general@lists.postgresql.org
References: 
 <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/bb7eeb84-5c47-169c-9353-d504436c2060%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------w74ksSzKYQKyqWHPHUwzAaL0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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?

What /*exactly*/ are you doing?


-- 
Angular momentum makes the world go 'round.
--------------w74ksSzKYQKyqWHPHUwzAaL0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 4/1/22 20:34, Shaozhong SHI wrote:<br>
    <blockquote type="cite"
cite="mid:CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_quote"><br>
          <div dir="ltr">
            <div dir="ltr">I have a script running to iterate over 4-5
              million rows.  It keeps showing up in red in PgAdmin.  It
              remains active.
              <div><br>
              </div>
              <div>How long does iteration over 4-5 million rows usually
                take?</div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    What <i><b>exactly</b></i> are you doing?<br>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------w74ksSzKYQKyqWHPHUwzAaL0--