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 1qb82i-00BBcK-Mp for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Aug 2023 23:22: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 1qb82h-00CdRB-LH for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Aug 2023 23:22:39 +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 1qb82h-00CdQx-Ac for pgsql-hackers@lists.postgresql.org; Tue, 29 Aug 2023 23:22:39 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb82d-001pNM-Uc for pgsql-hackers@postgresql.org; Tue, 29 Aug 2023 23:22:38 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 29A8F32002FB; Tue, 29 Aug 2023 19:22:33 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 29 Aug 2023 19:22:33 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm1; t=1693351352; x=1693437752; bh=hn SfmHYe5uIyxd+wyFNhYIfnITvBiDhiN/3SFnoFVn4=; b=X0OGbgtc3vMXZrEFuX dSaAxs/xeMUILHiTEFBcEsiPNXGIK/58TCSvNK7x+HbliBmEOh0an7wkLlUnOz0d VWkBzDgQud5SFJvH5wF30SkwWNrLjJLuAC6RJRhW3cG67RmlNhfuMeMU578o4dlp zwiBP91a2xxWAoU/QPwUuriJXHG+C1rn2bC2WITIg6iJaioTHIwnEYhfZrQyrJ+o gXm+WG7MUu11ndmDmAsj7ekThsdHRWwc7RRr4YxTSdHk29eSAj/lAjccGlVWJXD5 mYETBP5VWb8LUSnFuq4ek0xDQ3o9v3vpuhR9aA/VzRstWG9XF/9cpVInyUHPwPM9 dyAg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1693351352; x=1693437752; bh=hnSfmHYe5uIyx d+wyFNhYIfnITvBiDhiN/3SFnoFVn4=; b=lIc10z8iWpvP4cb8schjcpy6WvQq9 OJVOtYm48DiLrwhHpAetmNJGxLDvxqcu5tQ8P29xfdkKsEZyZX2C7UOdwzL7EbU4 dmquzjHa2MG/urK0Vz6YdUaRQghoVAW2p9dN76PjSbLjrh8LaCCDYCup8nEDamjC 4pixGV0BzQdMfqKjqFa8sXqV0K2WLQTGnLj3BfvrLM7/Xl+DUmDh3OxqHJYD4van gIs4tQN0nkgQ5e2tmC2/WH4aP8PjawV4t1P0QwJvo6WIb5o8o3cpkXBlqvOXUHXH nWBqOTHai7gdgcKkMpDy3Sakb3XnU/GK1yZVH0nux2KxLxfLx0h2nkR8w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudefjedgudelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 29 Aug 2023 19:22:30 -0400 (EDT) Date: Wed, 30 Aug 2023 08:22:27 +0900 From: Michael Paquier To: Nathan Bossart Cc: "Imseih (AWS), Sami" , Ian Lawrence Barwick , pgsql-hackers , "robertmhaas@gmail.com" Subject: Re: pg_stat_get_backend_subxact() and backend IDs? Message-ID: References: <20230824023206.GA1128857@nathanxps13.lan> <20230824025140.GB1128857@nathanxps13.lan> <20230824161913.GA1394441@nathanxps13.lan> <20230825153251.GA1593219@nathanxps13> <20230825192949.GA1917227@nathanxps13> <20230829164655.GA2138073@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ck5Bp49YHKXzPK3T" Content-Disposition: inline In-Reply-To: <20230829164655.GA2138073@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --ck5Bp49YHKXzPK3T Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 29, 2023 at 09:46:55AM -0700, Nathan Bossart wrote: > This was my first reaction [0]. I was concerned about renaming the > exported functions so close to release, so I was suggesting that we hold > off on that part until v17. If there isn't a concern with renaming these > functions in v16, I can proceed with something more like v2. Thanks for the pointer. This version is much better IMO, because it removes entirely the source of the confusion between the difference in backend ID and index ID treatments when fetching the local entries in the array. So I'm okay to rename these functions now, before .0 is released to get things in a better shape while addressing the issue reported. +extern LocalPgBackendStatus *pgstat_get_local_beentry_by_index(int beid);= =20 Still I would to a bit more of s/beid/id/ for cases where the code refers to an index ID, and not a backend ID, especially for the internal routines. -- Michael --ck5Bp49YHKXzPK3T Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmTufbMACgkQnvQgOdby QH0isw//VTGtqpq6l5AyOsazGzRJPn972iK60j5faSrAZ1t8BsV8KuoFVXQjPDf0 ttyx1i2udt2JYBbTv7rMZgBUEoQH+y5tLFWTrlypOwOetDA0SIQy7wPk3YAX1HUo bqaeMEyEXjfonmcV0WBPNimbgp7n7xdD1+3UlDqwJiIcs06cWYJvIi/dKkDLoWI3 mr+AjY2Ypb+g03kjDdF6h/fJMXj8cQw24dib3KuoNWvtonAyO4qHRT7Qav+yJtCq xGFhnexRa8+fK1bU9Njvthzo3epAmxsnh94uoFR/+KVl7jM3O0w4y402BQROwDFa YkxMFglqIACSa0tehm9drNH1eiT/Bo9tcKTh+n7Kw224AONic+Czymp1ciVbtvvT NVMuMN8NcUA7xxtuMQ+4PCY8+8xmdvfm7EBPvThL+uT0pxHj0Qdrk3SWlJ9laWLh 62FkkZY1Q0sCgEoMiwhEO16rjJpAOez8hTHMZ5TcjX/VBrfLjxwiUjWNthrHdLRJ 3DAu7JQurFfAkangm1XlfCbtqDMVrJRVq13Halzk3U2jqPO2aAGZNPmTfhlK4j1Y lPsTJzOdncorovHUB7brD3yXyuGUL8PKnKokr6yXe7pXO1rTpMKe5W3o+qvnq/DN JYStswL7beghP1Ax1n0OXtOABRKbfVTQaRf9CXhBj+/VtGFAOxU= =SkxV -----END PGP SIGNATURE----- --ck5Bp49YHKXzPK3T--