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 1tAHw5-00EqZv-0a for pgsql-committers@arkaria.postgresql.org; Mon, 11 Nov 2024 00:05:40 +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 1tAHw1-009yHP-P4 for pgsql-committers@arkaria.postgresql.org; Mon, 11 Nov 2024 00:05:38 +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 ) id 1tAHw1-009yHH-HH for pgsql-committers@lists.postgresql.org; Mon, 11 Nov 2024 00:05:38 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAHvz-001Cmu-Fp for pgsql-committers@lists.postgresql.org; Mon, 11 Nov 2024 00:05:36 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAHvx-003ijr-HI for pgsql-committers@lists.postgresql.org; Mon, 11 Nov 2024 00:05:34 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tAHvw-001Drx-Qc for pgsql-committers@lists.postgresql.org; Mon, 11 Nov 2024 00:05:33 +0000 Content-Type: multipart/mixed; boundary="===============1893425099787062108==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: pg_stat_statements: Avoid some locking during PGSS entry scans X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 11 Nov 2024 00:05:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1893425099787062108== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cGdfc3RhdF9zdGF0ZW1lbnRzOiBBdm9pZCBzb21lIGxvY2tpbmcgZHVyaW5nIFBHU1MgZW50cnkg c2NhbnMKCkEgc2luZ2xlIFBHU1MgZW50cnkncyBzcGlubG9jayBpcyB1c2VkIHRvIGJlIGFibGUg dG8gbW9kaWZ5ICJjb3VudGVycyIKd2l0aG91dCBob2xkaW5nIHBnc3MtPmxvY2sgZXhjbHVzaXZl bHksIGFzIG1lbnRpb25lZCBhdCB0aGUgdG9wIG9mCnBnX3N0YXRfc3RhdGVtZW50cy5jIGFuZCB3 aXRoaW4gcGdzc0VudHJ5LgoKV2l0aGluIGEgc2luZ2xlIHBnc3NFbnRyeSwgc3RhdHNfc2luY2Ug YW5kIG1pbm1heF9zdGF0c19zaW5jZSBhcmUgbmV2ZXIKbW9kaWZpZWQgd2l0aG91dCBob2xkaW5n IHBnc3MtPmxvY2sgZXhjbHVzaXZlbHksIHNvIHRoZXJlIGlzIG5vIG5lZWQgdG8KaG9sZCBhbiBl bnRyeSdzIHNwaW5sb2NrIHdoZW4gcmVhZGluZyBzdGF0c19zaW5jZSBhbmQKbWlubWF4X3N0YXRz X3NpbmNlLCBhcyBkb25lIHdoZW4gc2Nhbm5pbmcgYWxsIHRoZSBQR1NTIGVudHJpZXMgZm9yCmZ1 bmN0aW9uIGNhbGxzIG9mIHBnX3N0YXRfc3RhdGVtZW50cygpLgoKVGhpcyBhbHNvIHJlc3RvcmVz IHRoZSBjb25zaXN0ZW5jeSBiZXR3ZWVuIHRoZSBjb2RlIGFuZCB0aGUgY29tbWVudHMKYWJvdXQg dGhlIGVudHJ5J3Mgc3BpbmxvY2sgdXNhZ2UuICBUaGlzIGNoYW5nZSBpcyBhIHBlcmZvcm1hbmNl CmltcHJvdmVtZW50IChpdCBjYW4gYmUgYXJndWVkIHRoYXQgdGhpcyBpcyBhIGxvZ2ljIGJ1Zyks IHNvIHRoZXJlIGlzIG5vCm5lZWQgZm9yIGEgYmFja3BhdGNoLiAgVGhpcyBzYXZlcyB0d28gaW5z dHJ1Y3Rpb25zIGZyb20gYmVpbmcgcmVhZCB3aGlsZQpob2xkaW5nIGFuIGVudHJ5J3Mgc3Bpbmxv Y2suCgpBdXRob3I6IEthcmluYSBMaXRza2V2aWNoClJldmlld2VkLWJ5OiBNaWNoYWVsIFBhcXVp ZXIsIHdlbmh1aSBxaXUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUNpVDhpYmhD bXpiY094TTB2NHBSTEgzYWJrLTk1TFBrdDdfdUMySk1QK21pUGp4c2dAbWFpbC5nbWFpbC5jb20K CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81ZDQyOThlNzVmMjUyYjE2MjAwOGFkMDQ3NWYyOTM0OTAy MzU3M2NiCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL3BnX3N0YXRfc3Rh dGVtZW50cy9wZ19zdGF0X3N0YXRlbWVudHMuYyB8IDcgKysrKysrLQoxIGZpbGUgY2hhbmdlZCwg NiBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgo= --===============1893425099787062108==--