Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tN2cW-0088Yz-Gt
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2024 04:22:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tN2cT-002Sye-GG
	for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2024 04:22:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <rui.desousa@icloud.com>)
	id 1tN2cT-002SyW-39
	for pgsql-admin@lists.postgresql.org; Mon, 16 Dec 2024 04:22:10 +0000
Received: from qs51p00im-qukt01080301.me.com ([17.57.155.20])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <rui.desousa@icloud.com>)
	id 1tN2cR-0033NZ-9H
	for pgsql-admin@lists.postgresql.org; Mon, 16 Dec 2024 04:22:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com;
	s=1a1hai; t=1734322925;
	bh=OlU1pS3GJVppVnKmqJgZNhAGpRZDCpyOhgOjtILIX5U=;
	h=Content-Type:Mime-Version:Subject:From:Date:Message-Id:To:
	 x-icloud-hme;
	b=l1ZQ7q33F6q6tPU4V/avlXKINdQ7gPKfqlxHMIGvtlXSQ2WFUW1o3ES3MthG7lCGq
	 E0QMlX97rF7MaGSibngh98ngRuWP4BIYJKsv4zGAHRagF5BNiKsHjed+Ip+NP/ElOC
	 HLyg10NKD303luYvg96mWPPVtkbKMPIWmFhTHXD4f1S+P4JkYg2wXj/kRogblgqQcT
	 ysQHXKOJXL5IsWECoRzeRswjS1LVPxCrI+f9eR7GnyqRICdaBJOls/wc+hN5sPACrU
	 F6rrhRBavZQM4SWk7jvzeLMtzXq65z+IsFRD5h/7w8S9I+wOPCqW5BkgNFbtdEDw8T
	 fioA4x8wopLvQ==
Received: from smtpclient.apple (qs51p00im-dlb-asmtp-mailmevip.me.com
 [17.57.155.28])
	by qs51p00im-qukt01080301.me.com (Postfix) with ESMTPSA id 124605F0016D;
	Mon, 16 Dec 2024 04:22:05 +0000 (UTC)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.10\))
Subject: Re: Performance
From: Rui DeSousa <rui.desousa@icloud.com>
In-Reply-To: 
 <CAEphvJPSh1Cd+NA14Q3e-1B9JH6Ebm1oLgLx93HkkTZa=EBA_g@mail.gmail.com>
Date: Sun, 15 Dec 2024 23:22:02 -0500
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <0137F599-5558-4B33-9533-94D9E28B7CC2@icloud.com>
References: 
 <CAEphvJPSh1Cd+NA14Q3e-1B9JH6Ebm1oLgLx93HkkTZa=EBA_g@mail.gmail.com>
To: Anex Hul <anexsql2014@gmail.com>
X-Mailer: Apple Mail (2.3696.120.41.1.10)
X-Proofpoint-ORIG-GUID: _GUVs9O-BcObBFYpGDxCxlJSUuGKahfo
X-Proofpoint-GUID: _GUVs9O-BcObBFYpGDxCxlJSUuGKahfo
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.272,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34
 definitions=2024-12-16_01,2024-12-13_01,2024-11-22_01
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxlogscore=993
 adultscore=0
 bulkscore=0 malwarescore=0 clxscore=1011 spamscore=0 phishscore=0
 suspectscore=0 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.19.0-2308100000 definitions=main-2412160033
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/0137F599-5558-4B33-9533-94D9E28B7CC2%40icloud.com>
Precedence: bulk



> On Dec 15, 2024, at 8:22 PM, Anex Hul <anexsql2014@gmail.com> wrote:
>=20
> Hello everyone,
>=20
> Testing 100 million records data import from Azure blob storage to =
Azure postgresql. I did run the test 5 times and the time it took keep =
increasing for each run.=20
> Is there know justification for this linear increment of the time it =
took for same size of data?

Check you I/O quotas; you might have hit quota limits and being =
throttled.=