Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1msqnv-0003bn-V5 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Dec 2021 18:27:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1msqnu-00048W-JO for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Dec 2021 18:27:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mseai-0006vu-TI for pgsql-bugs@lists.postgresql.org; Thu, 02 Dec 2021 05:25:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mseaf-0007ae-GW for pgsql-bugs@lists.postgresql.org; Thu, 02 Dec 2021 05:25:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=njctMqrEOPHii1abK90AUb+0IMbQ0F2ihywVNywFc7M=; b=LQMpfYr/O5hYK0puhU0KCJFp1N kLIn2ISTD6byz6Xe++zzNs4dBUeBf1IE+fI84o+aWhkyU2hmvs0dmhtKnL8KMEN2pjcFYM+0KDZUp m/+Tf7YhfF9lr0ynDTYrgBVjGPWtLRcm1L2+9ZkdRbbFIKyhwA43bjOFecivqXSPiHmJ12An7k3Vj hGJUrNPFZpevKttRYERY0Y3EHtF+aPtt5hjRBXpGKiHcRoTVQZc7Kz9TZo63usUKqlR2Z0F8N4ksW bA0YvhYmEYtdfL3krmJ70wfleYVK427hFKIM2nsN9/ACW1xN6dd5ZCCJpNuZFIcg9hQAy4Q92lsx4 vKm5G+eA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1msead-0006Jp-Nx for pgsql-bugs@lists.postgresql.org; Thu, 02 Dec 2021 05:25:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mseac-00006I-5K for pgsql-bugs@lists.postgresql.org; Thu, 02 Dec 2021 05:25:02 +0000 Content-Type: multipart/mixed; boundary="===============3015978884564715289==" MIME-Version: 1.0 Subject: BUG #17307: Performance deviation between the multiple iterations (NOPM & TPM values). To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: researcherhpc@gmail.com Reply-To: researcherhpc@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 02 Dec 2021 05:24:23 +0000 Message-ID: <17307-45aac4924bf83586@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3015978884564715289== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzMwNwpMb2dnZWQgYnk6ICAgICAgICAgIEhQQyBSZXNlYXJjaGVyCkVt YWlsIGFkZHJlc3M6ICAgICAgcmVzZWFyY2hlcmhwY0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgUkhFTCA4LjQKRGVzY3JpcHRpb246ICAgICAg ICAKCk5PUE0gdmFsdWVzIGNhcHR1cmVkIHdpdGggSGFtbWVyREItdjQuMyBzY3JpcHRzIChzY2hl bWFfdHBjYy50Y2wgYW5kCnRlc3RfdHBjYy50Y2wgKSBmb3IgbXVsdGlwbGUgdHJhaWxzLg0KVGhl IGV4cGVjdGVkIHBlcmZvcm1hbmNlIGRldmlhdGlvbiBiZXR3ZWVuIG11bHRpcGxlIHRyaWFscyBz aG91bGQgYmUgbGVzcwp0aGFuIDIlIA0KDQpIYXJkd2FyZSBjb25maWd1cmF0aW9uIA0KQXJjaGl0 ZWN0dXJlICAgICAgICB4ODZfNjQgDQpDUFUgb3AtbW9kZShzKSAgICAgIDMyLWJpdCwgNjQtYml0 IA0KQnl0ZSBPcmRlcjogICAgICAgICAgTGl0dGxlIEVuZGlhbiANCkNQVShzKTogICAgICAgICAg ICAgIDI1NiANCk9uLWxpbmUgQ1BVKHMpIGxpc3Q6IDAtMjU1IA0KVGhyZWFkKHMpIHBlciBjb3Jl OiAgMiANCkNvcmUocykgcGVyIHNvY2tldDogIDY0IA0KU29ja2V0KHMpOiAgICAgICAgICAgMiAN Ck5VTUEgbm9kZShzKTogICAgICAgIDggDQpMMWQgY2FjaGU6ICAgICAgICAgICAzMksgDQpMMWkg Y2FjaGU6ICAgICAgICAgICAzMksgIA0KTDIgY2FjaGU6ICAgICAgICAgICAgNTEySyANCkwzIGNh Y2hlOiAgICAgICAgICAgIDE2Mzg0SyANCk9TOiBSSEVMOC40IA0KUkFNIFNJWkU6NTEyIA0KU1NE OjFUQiANCg0KDQoNClBvc3RncmVzcWwuY29uZiANCg0KYXV0b3ZhY3V1bV9tYXhfd29ya2VycyA9 IDE2IA0KYXV0b3ZhY3V1bV92YWN1dW1fY29zdF9saW1pdCA9IDMwMDAgDQpjaGVja3BvaW50X2Nv bXBsZXRpb25fdGFyZ2V0ID0gMC45IA0KY2hlY2twb2ludF90aW1lb3V0ID0gJzE1bWluJyANCmNw dV90dXBsZV9jb3N0ID0gMC4wMyANCmVmZmVjdGl2ZV9jYWNoZV9zaXplID0gJzM1MEdCJyANCmxp c3Rlbl9hZGRyZXNzZXMgPSAnKicgDQptYWludGVuYW5jZV93b3JrX21lbSA9ICcyR0InIA0KbWF4 X2Nvbm5lY3Rpb25zID0gMTAwMCANCm1heF93YWxfc2l6ZSA9ICcxMjhHQicgDQpyYW5kb21fcGFn ZV9jb3N0ID0gMS4xIA0Kc2hhcmVkX2J1ZmZlcnMgPSAnMTI4R0InIA0Kd2FsX2J1ZmZlcnMgPSAn MUdCJyANCndvcmtfbWVtID0gJzEyOE1CJyANCnJhbmRvbV9wYWdlX2Nvc3QgPSAxLjEgDQplZmZl Y3RpdmVfaW9fY29uY3VycmVuY3kgPSAyMDAgIA0KDQpIYW1tZXJEQiBTY3JpcHRzIA0KICAgID4+ Y2F0IHNjaGVtYS50Y2wgDQogICAgIyEvYmluL3RjbHNoIA0KICAgIGRic2V0IGRiIHBnIA0KICAg IGRpc2V0IGNvbm5lY3Rpb24gcGdfaG9zdCBsb2NhbGhvc3QgDQogICAgZGlzZXQgY29ubmVjdGlv biBwZ19wb3J0IDU0MzIgDQogICAgZGlzZXQgdHBjYyBwZ19jb3VudF93YXJlIDQwMCANCiAgICBk aXNldCB0cGNjIHBnX251bV92dSA1MCANCiAgICBwcmludCBkaWN0IA0KICAgIGJ1aWxkc2NoZW1h IA0KICAgIHdhaXR0b2NvbXBsZXRlIA0KDQpSVU4gVEVTVCBvbiBpLmUuIHN0YXJ0IHdpdGggMVZV IHRoZW4gMiwgNCBldGMgDQogICAgICBWaXJ0dWFsIFVzZXJzICAgVHJhaWwtMShOT1BNKSBUcmFp bC0yKE5PUE0pCSVkaWZmCSANCiAgICAgICAgMTIJCTk5MzkwCSAgICAgICAgICAgOTI5MTMJICAg ICAgICAgICAgICA2LjUxNjc1MiAgDQogICAgICAgIDE0MAkJNTYxNDI5CSAgICAgICAgICAgNTI1 NDA4CSAgICAgICAgICAgICAgNi40MTU5NDkgIA0KICAgICAgICAxOTIJCTYzNjAxNgkgICAgICAg ICAgIDQ5OTU3NAkgICAgICAgICAgICAgIDIxLjQ1MjYgIA0KICAgICAgICAyMzAJCTYyMTY0NAkg ICAgICAgICAgIDcwMTg4MgkgICAgICAgICAgICAgIDEyLjkwNzQKCg== --===============3015978884564715289==--