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 1nDgEA-0001nS-BX for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Jan 2022 05:24:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nDgE9-0007Tf-2l for pgsql-hackers@arkaria.postgresql.org; Sat, 29 Jan 2022 05:24:45 +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 1nDgE7-0007TW-CS for pgsql-hackers@lists.postgresql.org; Sat, 29 Jan 2022 05:24:44 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nDgE2-0002jn-OZ for pgsql-hackers@lists.postgresql.org; Sat, 29 Jan 2022 05:24:43 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 6CCD13200E86; Sat, 29 Jan 2022 00:24:33 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 29 Jan 2022 00:24:34 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc: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=fm3; bh=VI26bBMyV2Uy/3A4Zjl0P3rTUMSTZa1Ea2jWaL 1WEbw=; b=ssSOQCi1Fv1f0f29rdANocfh/JpCYrOZ83xF82FGJScBIvRne2VRYL DS3UPZ6rW8U62GwiQ+DlJ71GHmfSGHjkePCfmvh+pF4pdeymPw34wVsSbeC6IkTq hs4o/oiZnOWrDWPrmHGkohtdb7/Sc5mV4LxjkK/LG2ne59VE+EvNcO8m/TFPx0yW pyYHispnzx9DKJ/ZyX7/185AH6n9GPYUWmB3TZQWHxLyaehzheAwSHBpXRGew+VO hrmJKTHZ1wtoSyCIJFHMMiQfnof/rzgCgQOZ24yCSoz9L92R71a+SnL4SmuDOSKW rK8Lp/krYvqSmEPudxmA6ga6DdzhrTog== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date: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; bh=VI26bBMyV2Uy/3A4Z jl0P3rTUMSTZa1Ea2jWaL1WEbw=; b=ZgTFTtZTYyphMVqiBk/13R989e5t3CngX pDIY010S3sXwJbW0DIhsdc5kVQv/bUyCZI3z6ankZPS+smUqg97W5BzUfgMJdGq1 YHGpWAxyJfyPbweo6L+++1f9P81lBwgx1ltVS2KR45kbIvWeKAiTIRw6fpZNLnMd zJhn7GYMI0FrDricEMVnElRwVyNkRLdZcwQr/xLFsDqvcwI5AWhOMfbuFoNiDc9X DLyiDj/vOCW0rxlSp3uSZYS52NmFwrtpNFItO/ANS35XR0PDNM5kHuNfrF7FU0zf WjU0VhQSbNC2tQBC9G71hCfiTQuj35/czPFi0OSHN9UsW49jf9nTw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrfeeigdekvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 29 Jan 2022 00:24:27 -0500 (EST) Date: Sat, 29 Jan 2022 14:24:24 +0900 From: Michael Paquier To: Nathan Bossart Cc: "Bossart, Nathan" , Robert Haas , Fujii Masao , "wangsh.fnst@fujitsu.com" , Andres Freund , Bharath Rupireddy , Greg Sabino Mullane , Tom Lane , "pgsql-hackers@lists.postgresql.org" Subject: Re: make MaxBackends available in _PG_init Message-ID: References: <01c32f6c-8101-1ce4-8295-534cf067df94@oss.nttdata.com> <7239E4F9-A46D-4A61-9200-8B1366D03ADB@amazon.com> <1E960D8B-24D7-43E0-9744-C5F8C52DDEB4@amazon.com> <20220127181815.GA551692@nathanxps13> <20220129043342.GA89174@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="l5X/R5KbV3Qfed8j" Content-Disposition: inline In-Reply-To: <20220129043342.GA89174@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --l5X/R5KbV3Qfed8j Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Jan 28, 2022 at 08:33:42PM -0800, Nathan Bossart wrote: > Hm. Perhaps we should understand the full scope of the problem first. > What else besides MaxBackends and the shared memory GUCs won't be properly > initialized when the shared_preload_libraries' _PG_init() functions are > called? MaxBackends seems to be the only one that folks have experienced > problems with, which is why I initially zeroed in on it. Yeah, it would be good to know the scope before defining the limits of what could be done. Another thing may be the interactions with session_preload_libraries and local_preload_libraries. -- Michael --l5X/R5KbV3Qfed8j Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmH0z4gACgkQnvQgOdby QH0MCxAAkvcLmhmHZqZim0HQcLKjsunmHPRu8R+Zkqosl3sMDaqSlvBxvacaqTpD 4ybqpmotcu3Uqya62Su/eNIqs3xwbN2eekYdMKST4uWJkuK6V0qzg0g3IWYnNY0o hsnLblmDjqXWAFV4p5NTK2EPeABDAZNmJjfnLsGwSwu+QplvGzdWVNTgxF0UEAT8 x33aJW2Jz4ys4amsgf9dc2XvKcFUFy5Qiz00GaocRKwjEtZlLVilPtCI+JALZ0Fo hsxUAJdPz18WagfB9KGkOKyu9TltYqt7MAsPtV3XEqD5KSF+FzAJ5b8PTFUbRncm ZnfFheQUBsMCYq83DeWuZRsFfwQNfqoiyFK2ggCH2wA9ziXc1Qs6J/SW0xEEPyhI mvVsC2UDG5VlxLZm4XyIJvWcGxrg3B731vdzC7SkD1kZ+3lUiO+AiMWpRMrhU61B lVgzOJt+LjBxN/ubwosVnmFDeaVAdY/USPkvfjiuL3w27S7AQwPHV6g4Jdn4rlkh Q7gpjYnn2/jzM/5KlzL3wII0jMEN1Xqvg26xyKD/g7rwmnsRH1FQxMqPcxqrJ3x7 VAT0ocKuNkYatSNFw6hI22qvnl+FLDl7FeAioPRGHSSjOdk79NdJhnAkuwMUtdE6 DfxxGRixQ7NOst525qrGG7kqaumeCAbDb8quUH49y1ZFYCR0xM0= =v7ks -----END PGP SIGNATURE----- --l5X/R5KbV3Qfed8j--