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 ) id 1tMzod-007ozQ-Ug for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2024 01:22:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tMzoa-001ETy-6i for pgsql-admin@arkaria.postgresql.org; Mon, 16 Dec 2024 01:22:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMzoZ-001ETq-PY for pgsql-admin@lists.postgresql.org; Mon, 16 Dec 2024 01:22:29 +0000 Received: from mail-ed1-x52c.google.com ([2a00:1450:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tMzoY-0033oI-Sh for pgsql-admin@lists.postgresql.org; Mon, 16 Dec 2024 01:22:28 +0000 Received: by mail-ed1-x52c.google.com with SMTP id 4fb4d7f45d1cf-5d3e829ff44so8538985a12.0 for ; Sun, 15 Dec 2024 17:22:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734312144; x=1734916944; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=m3zVoB12azuZKvDDr01FmviCkGlbDn2zilph/fxGhok=; b=aEWbtAQSxT6LPbpbR2Xa7x4ebZoFCNmAdnukBG2n7PhUbUzyqpE8NXbRfQDMYCHn6H EFfBf2NyhDKQrTnkHthn4TfZ/aIRVg/z1VLe5a/BDIm1y6hrAyDCv+1S/CtaPcU1/hz/ kZY9aAu+oZ+NLE9AMAuYBjY4uc2+ZLz96HnrTmaUvTHdkI1VHiJQ8BGpv/JTdT5M5Gxp N8iTiNcY41IazefsbWYfSsKeECmKu59j9etPPzE60ChYLgJONX3I//QZwSDGj3+K6Au3 SPnRi+ZGWtjit2RobNl58vXRnbVNEM4pAup90TzM0r3O7QhGe939fvxDgVyUlG4pHVf8 MzkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734312144; x=1734916944; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=m3zVoB12azuZKvDDr01FmviCkGlbDn2zilph/fxGhok=; b=HaGLXs7ZQoo8Ff1TcSkEVJcDofwHiA30WgWCtwksu9jX16WPzKZTgFEVu2+5wWo9Cm BgWncUnBbK/q0EKTF/DcPkluAFVpMNonNngy79Z7iU8VWR9LWVC0eIjawqQpRu6gy12c yM2yIeAfoydE4xSUelU5TLNelRakoXWqxS0vWzVIoWLiCJQ2AgK10zBZjdTKclOt/Nu8 quWJApXkrm+rqCp1ugEilzbWJ2a81m50CJQFaBTLrBZeCn6LWIVTxfHr4qKwF7no8RVj SKhl3nsCHTnox57Obh+ELS7WS8A+LKBSRD7wQL2KQk4OXPqXZUmVf5atvw8Fpi1i9LeW 2tGw== X-Gm-Message-State: AOJu0Yzy6en8afvJkDbrCwFwUr44YDnOrGbhffwA4h3WNj5cLdhXV3Tp +xaFMoueTFEAm7jmlafF91lR+9DSfVvq9/LIkc21ilRU/AMFzcIlU6OmvOnvV1NDIkya+YH1i0O qunt1+W0aLKifq69mbW02T3i9RLJupQ== X-Gm-Gg: ASbGncsduRqDkk4ryscVL/5sWxWsFh3/p4bbSy4Sb2pHJFWSjec8D/iAPzecj1DZ8X9 3nV7uD40b0yyUcPLmFCiWbPJk9l51L7Ku0ITh4K2IwzTVEUDEbUgR0XosuOrFg8T++ghvhHo= X-Google-Smtp-Source: AGHT+IEbjRK7WoaOmlDS7pWiUQJ6egYZc2qrrLXWVMxMc//CALR/9JMophhM/S1LLRLrbXhw4FmfNFs2R7Vdv6NKOpw= X-Received: by 2002:a17:907:6ea2:b0:aa6:950c:ae1a with SMTP id a640c23a62f3a-aab7bb653b4mr927487866b.30.1734312144319; Sun, 15 Dec 2024 17:22:24 -0800 (PST) MIME-Version: 1.0 From: Anex Hul Date: Sun, 15 Dec 2024 19:22:13 -0600 Message-ID: Subject: Performance To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004abb370629590320" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004abb370629590320 Content-Type: text/plain; charset="UTF-8" Hello everyone, 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. Is there know justification for this linear increment of the time it took for same size of data? --0000000000004abb370629590320 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello everyone,

Testing 100 million records data import from Azure blob storage to Azur= e postgresql. I did run the test 5 times and the time it took keep increasi= ng for each run.=C2=A0
Is there know justification f= or this linear increment of the time it took for same size of data?
--0000000000004abb370629590320--