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 1mPhNe-0008FP-6H for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Sep 2021 08:31:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mPhNd-0004hj-3A for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Sep 2021 08:31:57 +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 1mPead-0005xg-He for pgsql-bugs@lists.postgresql.org; Mon, 13 Sep 2021 05:33:11 +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 1mPeaX-00050C-9P for pgsql-bugs@lists.postgresql.org; Mon, 13 Sep 2021 05:33:11 +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=aPJQX+54bbM9i63io++ZJu42fvaEMOBObtKUDUSGSgE=; b=ZraIYatqktsn1825tCH7T3Glso qSZ1JnlKIn2PAJ+SmsvXhBRHQ4ACSiXFpJAkx2W6DmRTWD/ZIlFIqTSqsBHfQjKjccxbwcCNh9bUe 2ocG8xI4qw7eVN3MCduF6NbRBQffxwjiM3BmtQv+VBM9s+ZqhbznOijbKcnP2AOSfn0H94UKKPs5G CjXRzY+W8UYnR/BFSJgJqjr4+5+Et7rkGgUzXLQ+QCyNOOXofql5/IhJCYqIOXhWoU3j0mbJcFVgF u9E6CmnFT03Y56eoNYxKq5U2S3V79IEh64QavY6JL9hfTWoTQ8PVvOg0Sp2YH3ZQUL4xisIDAATNq Sn039oPQ==; 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 1mPeaW-0008KX-0O for pgsql-bugs@lists.postgresql.org; Mon, 13 Sep 2021 05:33:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mPeaU-0007p8-HL for pgsql-bugs@lists.postgresql.org; Mon, 13 Sep 2021 05:33:02 +0000 Content-Type: multipart/mixed; boundary="===============0757191068976185482==" MIME-Version: 1.0 Subject: BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ashkildighin76@gmail.com Reply-To: ashkildighin76@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 13 Sep 2021 05:32:51 +0000 Message-ID: <17190-0efc34364b607e0d@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 --===============0757191068976185482== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzE5MApMb2dnZWQgYnk6ICAgICAgICAgIGFzaGtpbCBkaWdoaW4KRW1h aWwgYWRkcmVzczogICAgICBhc2hraWxkaWdoaW43NkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMy4zCk9wZXJhdGluZyBzeXN0ZW06ICAgUkhFTDguNApEZXNjcmlwdGlvbjogICAgICAg IAoKRXhhbXBsZSBQZXJmIGRhdGEgZm9yIDI0dnUoVFBDQykNCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tDQoNCiAgICAgMjAuOTklICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAgICAgICAg ICBbLl0gTFdMb2NrQWNxdWlyZQ0KICAgICA3LjA5JSAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAg ICAgICAgWy5dIF9idF9jb21wYXJlDQogICAgIDguNjYlICBwb3N0Z3JlcyAgcG9zdGdyZXMgICAg ICAgICAgICBbLl0gTFdMb2NrUmVsZWFzZQ0KICAgICAyLjI4JSAgcG9zdGdyZXMgIHBvc3RncmVz ICAgICAgICAgICAgWy5dIEdldFNuYXBzaG90RGF0YQ0KICAgICAyLjI1JSAgcG9zdGdyZXMgIHBv c3RncmVzICAgICAgICAgICAgWy5dIGhhc2hfc2VhcmNoX3dpdGhfaGFzaF92YWx1ZQ0KICAgICAy LjExJSAgcG9zdGdyZXMgIHBvc3RncmVzICAgICAgICAgICAgWy5dIFhMb2dJbnNlcnRSZWNvcmQN CiAgICAgMS45OCUgIHBvc3RncmVzICBwb3N0Z3JlcyAgICAgICAgICAgIFsuXSBQaW5CdWZmZXIN CklzIHRoZXJlIHdheSB0byB0dW5lIHRoZSBsb2NrIGNvbnRlbnRpb24gPw0KSXMgYW55IHJlY29t bWVuZGF0aW9ucyB0byB0dW5lL3JlZHVjZSB0aGUgbG9jayBjb250ZW50aW9uIHZpYQpwb3N0Z3Jl cy5jb25mKGxpa2UgYnVmZmVycykuDQpQb3N0Z3Jlcy5jb25mIA0KPT09PT09PT09PT0NCnNoYXJl ZF9idWZmZXJzID0gNjQwMDBNQiAgICAgICAgICAgICAgICAgICAgICAgIA0KaHVnZV9wYWdlcyA9 IG9uICAgICAgICAgICAgICAgIA0KdGVtcF9idWZmZXJzID0gNDAwME1CICAgICAgICAgICAgICAg ICAgDQp3b3JrX21lbSA9IDQwMDBNQiAgICAgICAgICAgICAgICAgICAgICANCm1haW50ZW5hbmNl X3dvcmtfbWVtID0gNTEyTUIgICAgICAgICAgIA0KYXV0b3ZhY3V1bV93b3JrX21lbSA9IC0xICAg ICAgICAgICAgICAgDQptYXhfc3RhY2tfZGVwdGggPSA3TUIgICAgICAgICAgICAgICAgICANCmR5 bmFtaWNfc2hhcmVkX21lbW9yeV90eXBlID0gcG9zaXggICAgIA0KbWF4X2ZpbGVzX3Blcl9wcm9j ZXNzID0gNDAwMCAgICAgICAgICAgDQplZmZlY3RpdmVfaW9fY29uY3VycmVuY3kgPSAzMiAgICAg ICAgICANCndhbF9sZXZlbCA9IG1pbmltYWwgICAgICAgICAgICAgICAgICAgIA0Kc3luY2hyb25v dXNfY29tbWl0ID0gb2ZmICAgICAgICAgICAgICAgDQp3YWxfYnVmZmVycyA9IDUxMk1CICAgICAg ICAgICAgICAgICAgICANCiNjaGVja3BvaW50X3NlZ21lbnRzID0gMjU2ICAgICAgICAgICAgIA0K Y2hlY2twb2ludF90aW1lb3V0ID0gMWggICAgICAgICANCmNoZWNrcG9pbnRfY29tcGxldGlvbl90 YXJnZXQgPSAxICAgICAgIA0KY2hlY2twb2ludF93YXJuaW5nID0gMCAgICAgICAgIA0KbG9nX21p bl9tZXNzYWdlcyA9IGVycm9yICAgICAgICAgICAgICAgDQpsb2dfbWluX2Vycm9yX3N0YXRlbWVu dCA9IGVycm9yDQpsb2dfdGltZXpvbmUgPSAnR0InDQphdXRvdmFjdXVtID0gb2ZmICAgICAgICAg ICAgICAgICAgICAgICANCmRhdGVzdHlsZSA9ICdpc28sIGRteScNCnRpbWV6b25lID0gJ0dCJw0K bGNfbWVzc2FnZXMgPSAnZW5fR0IuVVRGLTgnICAgICAgICAgICAgDQpsY19tb25ldGFyeSA9ICdl bl9HQi5VVEYtOCcgICAgICAgICAgICANCmxjX251bWVyaWMgPSAnZW5fR0IuVVRGLTgnICAgICAg ICAgICAgIA0KbGNfdGltZSA9ICdlbl9HQi5VVEYtOCcgICAgICAgICAgICAgICAgDQpkZWZhdWx0 X3RleHRfc2VhcmNoX2NvbmZpZyA9ICdwZ19jYXRhbG9nLmVuZ2xpc2gnDQptYXhfbG9ja3NfcGVy X3RyYW5zYWN0aW9uID0gNjQgICAgICAgICANCm1heF9wcmVkX2xvY2tzX3Blcl90cmFuc2FjdGlv biA9IDY0Cgo= --===============0757191068976185482==--