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 1tLa9B-00Fh2T-Ib for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 03:45:53 +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 1tLa8A-006LTV-DU for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Dec 2024 03:44:51 +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 1tLa8A-006LTM-3M for pgsql-hackers@lists.postgresql.org; Thu, 12 Dec 2024 03:44:51 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLa88-002OOL-EP for pgsql-hackers@postgresql.org; Thu, 12 Dec 2024 03:44:50 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 5431D11401BA; Wed, 11 Dec 2024 22:44:47 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Wed, 11 Dec 2024 22:44:47 -0500 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:subject :subject:to:to; s=fm1; t=1733975087; x=1734061487; bh=qR6Kqj9D/R F0s9xhqHopwT8A3yg+WVMRW0hIXB9Ngjg=; b=gOVuYX63kiDCRyF4rPkTK3ULQV EOlFD2dOZ43dL8s0BhojClQY2iDZ5FIU1qIz5DI54DUhpG9XVkHOM5Xyd8kT4HCt OOBme4AKBdbmPkuEQiWu9CE+xE5oyo6sD8v+qE4+wOshcow+9RIQHSsaXrVpWdFV GjBN+xEGsKLl2DKplLa9WUxph7Gd2T68fgk3eEgvh40fA4nX1wA44hRFJl66jSuu pKx3qnblaf6DGoHpIcgo+MtBfP3/wWNECmnhcyf+3OIOUx+j2P+rJSsxxhL/0NFo e+BTLilE+XEAEgjq6I5qyGr12zrIaA0X85fJl4YzkhadPBB2Neh5isMg7nbQ== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1733975087; x=1734061487; bh=qR6Kqj9D/RF0s9xhqHopwT8A3yg+WVMRW0h IXB9Ngjg=; b=ED32a8E5YYr4u7yYDcbBQXsh7vEgeImQGpmrQ7Ax4zlnScVk4zs qhCb1Pvj47nsEGXvuvy3g0eL0dN3hFdiGRVp+GZCyQ3Bn2TmkOzJm+z7njm9Uc46 D19EuBx/AeIYbBBpAzSN4EIf9f0JuYKDPfFaZo0KUdFLK/d5H/sh97WFZx+HbZ2I Hlc32BzIWq/Haa6/001RMY9RM0eTaAJe5Q6JOtHIIASGmk8iPTcEQhf6DlZ5hERD n1EGJWv/BwHoFIOQusv69KcOPHvo37oDCr5PvQR2mM6wPTBCsxg3j3Qe8DxbX0Qm Y6NPARkaLhB7wYtBpRqtYK1+hm0oPQSI1mQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeefgddtjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhgg tggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoe hmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleei fedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehp rghquhhivghrrdighiiipdhnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepvghu lhgvrhesvghulhgvrhhtohdrtghomhdprhgtphhtthhopegrnhgurhgvshesrghnrghrrg iivghlrdguvgdprhgtphhtthhopehlvghpihhhohhvsehgmhgrihhlrdgtohhmpdhrtghp thhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Dec 2024 22:44:44 -0500 (EST) Date: Thu, 12 Dec 2024 12:44:34 +0900 From: Michael Paquier To: Tom Lane Cc: Euler Taveira , Andres Freund , Andrei Lepikhov , pgsql-hackers Subject: Re: Add Postgres module info Message-ID: References: <506788.1733941263@sss.pgh.pa.us> <2qdclwljzvw5abfvo4porr3ehox32icrbtfjaum327ruxts6qm@udexcbweewpq> <556165.1733967268@sss.pgh.pa.us> <570943.1733974778@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="cMjlm9BPjlVCcGwM" Content-Disposition: inline In-Reply-To: <570943.1733974778@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --cMjlm9BPjlVCcGwM Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Dec 11, 2024 at 10:39:38PM -0500, Tom Lane wrote: > Michael Paquier writes: >> Presumably, >> the extra tracking can be done in dfmgr.c with more fields added to >> DynamicFileList to track the information involved. >=20 > I wouldn't add any overhead to the normal case for this. Couldn't > we walk the list and re-fetch each module's magic block inside > this new function? Depends on how much we should try to cache to make that less expensive on repeated calls because we cannot unload libraries, but sure, I don't see why we could not that for each SQL function call to simplify the logic and the structures in place. -- Michael --cMjlm9BPjlVCcGwM Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmdaXCIACgkQnvQgOdby QH3HqBAAnG0PFOl9G8brYevy0YnrwOhIzXlrMZOgvBdImfRJyKuEHsoeuYoiz7wp ZB36S8cnYL4KCjoxhIYv/wNlNSDhmb/6CSyyTzcGoPJnBi0/0+Ru4FE1CuCrG15p DJ91G77WvWkNf7djTdfkU5BBEHsg4A6R8uyDbXXSaSRTnwtOHsXFC2VoYJbYBjnw jslTm0qReXn+dUhrP54T+sEsA76S1v2BDWtEtZkS/gsnAyFHJY7PDf2/tTnt9W1f rtq0RpOVKl/WP8f0W0HAsqOuDPWqECP1uRkpFBz97JwfTjtTCDn+ugLWjc6RZSMS SwVJTDUSUK3VwAQe5M/nLfJQf9c0aZOFaZ3onhZqKmGPbAgfx1nQ5PnQ3Q66X8+P bNqkX8OB64rHi1Qh10XWHJpJPv9D5fJVWpmSySM0vjytJGT3WJ2tD678BKDqbuoi nWUScQJY71NsNQSNhT1SoYZwGYDuYc1PAl076cD2HzFzMJ3Y94fHWDAsQrStEhdx 0mPluGqiGljJah2tQgGk06ogPw3+c6pDXkswjpT7zTiKhAHP29aKWPmhUxKUPh2X 9eFfRtGYGVxVnzEyVJaHc3nyTjzCA/dr6fQFsuHbnGBNHGJTaX67waW3knkcIOKl T06eNiJgJISHZyX7Bi1AUJgI54ZAp1YpvuIH8l6bAfJXkehF0Ps= =sk8w -----END PGP SIGNATURE----- --cMjlm9BPjlVCcGwM--