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 1tt5Rl-008SQ7-8h for pgsql-committers@arkaria.postgresql.org; Fri, 14 Mar 2025 13:51:33 +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 1tt5Rj-007wq0-EP for pgsql-committers@arkaria.postgresql.org; Fri, 14 Mar 2025 13:51:31 +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 1tt5Rj-007wnO-6R for pgsql-committers@lists.postgresql.org; Fri, 14 Mar 2025 13:51:31 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tt5Re-002qOV-2t for pgsql-committers@lists.postgresql.org; Fri, 14 Mar 2025 13:51:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=+9Ax4Z23iGSPZpPbYawoJcQDe4qkGjZvIl7adqVI+5M=; b=Z64Urhio2D4rBHaDHI/oZ/1AyG aREnICSJiZ4FBgEYYnl7TKVSWPMTicFf1Ht6mtOm+8zoQCLb0ET/E5ZXjvlI4vlogd6m1X2XCnVjI 0UTEsUnXjOV72yqCaLGZ0vmSkRX/hzYoDMB+czp8CE4QnYBngBkugQNosNiJonaNivrtj4/2Ss38l /Rsnzu+FD0ot73GZSmEFU5QpP3sbuct3iyAJdQgzkAi4d4wOFvs2Xd2vgWQnr7oa2PMSSXfdoyo3D cnAlWbUzUHNCMtxowEhBGptotMMbL759xXNVKO+Pl+VoODXIYX8Z8PEJBKFqNibiZ6v+NbD7dEXbq dQ4fIrDg==; 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 1tt5Re-007Gp3-Pl for pgsql-committers@lists.postgresql.org; Fri, 14 Mar 2025 13:51:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tt5Rd-002Rk0-2X for pgsql-committers@lists.postgresql.org; Fri, 14 Mar 2025 13:51:25 +0000 Content-Type: multipart/mixed; boundary="===============8853753356916153232==" MIME-Version: 1.0 From: Fujii Masao To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize iteration over PGPROC for fast-path lock searches. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 14 Mar 2025 13:51:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8853753356916153232== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgaXRlcmF0aW9uIG92ZXIgUEdQUk9DIGZvciBmYXN0LXBhdGggbG9jayBzZWFyY2hl cy4KClRoaXMgY29tbWl0IGltcHJvdmVzIGVmZmljaWVuY3kgaW4gRmFzdFBhdGhUcmFuc2ZlclJl bGF0aW9uTG9ja3MoKQphbmQgR2V0TG9ja0NvbmZsaWN0cygpLCB3aGljaCBpdGVyYXRlIG92ZXIg UEdQUk9DcyB0byBzZWFyY2ggZm9yCmZhc3QtcGF0aCBsb2Nrcy4KClByZXZpb3VzbHksIHRoZXNl IGZ1bmN0aW9ucyByZWNhbGN1bGF0ZWQgdGhlIGZhc3QtcGF0aCBncm91cCBkdXJpbmcKZXZlcnkg bG9vcCBpdGVyYXRpb24sIGV2ZW4gdGhvdWdoIGl0IHJlbWFpbmVkIGNvbnN0YW50LiBUaGlzIHVw ZGF0ZQpvcHRpbWl6ZXMgdGhlIHByb2Nlc3MgYnkgY2FsY3VsYXRpbmcgdGhlIGdyb3VwIG9uY2Ug YW5kIHJldXNpbmcgaXQKdGhyb3VnaG91dCB0aGUgbG9vcC4KClRoZSBmdW5jdGlvbnMgYWxzbyBu b3cgc2tpcCBlbXB0eSBmYXN0LXBhdGggZ3JvdXBzLCBhdm9pZGluZwp1bm5lY2Vzc2FyeSBzY2Fu cyBvZiB0aGVpciBzbG90cy4gQWRkaXRpb25hbGx5LCBncm91cHMgYmVsb25naW5nIHRvCmluYWN0 aXZlIGJhY2tlbmRzICh3aXRoIHBpZD0wKSBhcmUgYWx3YXlzIGVtcHR5LCBzbyBjaGVja2luZwp0 aGUgZ3JvdXAgaXMgc3VmZmljaWVudCB0byBieXBhc3MgdGhlc2UgYmFja2VuZHMsIGZ1cnRoZXIg ZW5oYW5jaW5nCnBlcmZvcm1hbmNlLgoKQXV0aG9yOiBGdWppaSBNYXNhbyA8bWFzYW8uZnVqaWlA Z21haWwuY29tPgpSZXZpZXdlZC1ieTogSGVpa2tpIExpbm5ha2FuZ2FzIDxobGlubmFrYUBpa2ku Zmk+ClJldmlld2VkLWJ5OiBBc2h1dG9zaCBCYXBhdCA8YXNodXRvc2guYmFwYXQub3NzQGdtYWls LmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8wN2Q1ZmQ2YS03MWYxLTRjZTgt ODYwMi00Y2M2ODgzZjRiZDFAb3NzLm50dGRhdGEuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ZTgwMTcxZDU3YzI1Y2FmNDM2MmE3ZGUxN2U5NjE5NWY5MDUzODZlYQoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvc3RvcmFnZS9sbWdyL2xvY2suYyB8IDI4ICsrKysr KysrKysrKysrKystLS0tLS0tLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDE2IGluc2VydGlvbnMoKyks IDEyIGRlbGV0aW9ucygtKQoK --===============8853753356916153232==--