Message-ID: <3ad78742-7ce3-f2cd-e7c4-84a6e8e30ae5@aklaver.com>
Date: Fri, 1 Apr 2022 18:47:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.7.0
Subject: Re: How long does iteration over 4-5 million rows usually take?
Content-Language: en-US
To: Shaozhong SHI <shishaozhong@gmail.com>,
 pgsql-general <pgsql-general@lists.postgresql.org>
References: 
 <CA+i5JwbVEfirA08UmE2D4gjpoeKK8vS7AuBL+nJ-M+SDvGHZpA@mail.gmail.com>
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: 
 <CA+i5JwYtma8t7OQGmLwS_fmk7iHQgm8AfuM520mSS-dYcP8oQA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/3ad78742-7ce3-f2cd-e7c4-84a6e8e30ae5%40aklaver.com>
Precedence: bulk

On 4/1/22 18: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?

Given that there is no real information provided in the problem 
description there is no chance for an answer more detailed then; as long 
as it takes.

> 
> Regards,
> 
> David


-- 
Adrian Klaver
adrian.klaver@aklaver.com