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 1mSVXD-0002JT-5s for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Sep 2021 02:29:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSVXB-0004pQ-MA for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Sep 2021 02:29:25 +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 1mSVXB-0004pI-EC for pgsql-hackers@lists.postgresql.org; Tue, 21 Sep 2021 02:29:25 +0000 Received: from new2-smtp.messagingengine.com ([66.111.4.224]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSVX5-0007vk-1L for pgsql-hackers@postgresql.org; Tue, 21 Sep 2021 02:29:25 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailnew.nyi.internal (Postfix) with ESMTP id 29550580B46; Mon, 20 Sep 2021 22:29:16 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Mon, 20 Sep 2021 22:29:16 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=TubfXx/l9xoohck88yicKNPARDX BjpGPFVhZ7yT5THM=; b=uQ3PN4qCslmj2GVVoN9AtUJGsFGbxm+fLzpH22CTTsN k1I4AK1EBq0U+XY7E5KNJhcssdqH8c2cwDL9GNeg8cOfVVxBhc41bHfP74R86qkz 8o2SzZAgfzjQsIG4qC/XHQpexGZkmCT4o7pUx5Vavf7VB8Ds6VUPPEmrktxbWXt3 yTjJha61K7XGxs4KnzpLLRzz9KT0zNpA2npoUM6T/2A51EQWyet2HBJBRGKHeL1W q0Asp3qmpjccApx2TwtCWcc78YZxnBxrRtolJVUNS2jSo//tb/3+iuj3DRbNMnmM okokJDu70ZPhysSAoLHTCKmWgHGsnh7lUsmjwureGbQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=TubfXx /l9xoohck88yicKNPARDXBjpGPFVhZ7yT5THM=; b=nB5Rti2wzR3Nu1YM3SezKE WXy9d92kknmW1xtayW1ir8oqL3vR6BRTio9t+dvLO0NpYyAM+vUJQpoAmWni5Cyi YcO1Fw8uzOAgIbbD+uDhinJn1ez2zVeuyI+hdB1pdKVaSxd6Bvk5epYcYIjKIqog 3M8UKeMxdC4DTduELxViZxKXWurCeOpUhYkKW1pzJgeR0sX0426OmhL1gfc9twc7 xIwXVIpFgZCjrxonRmMD1hzYalPluTLTPLojXZQXGukEDQpc6Jaq2ilVrrjRTN3Z 9rVL/RUstSNLiCuKTo1iKEaneDZqUWWBO2QQgjdfArz+qbzCN8U4ySNdhS5Wj/HA == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudeifedgheelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 20 Sep 2021 22:29:11 -0400 (EDT) Date: Tue, 21 Sep 2021 11:29:07 +0900 From: Michael Paquier To: "Bossart, Nathan" Cc: Justin Pryzby , Kyotaro Horiguchi , "tgl@sss.pgh.pa.us" , "robertmhaas@gmail.com" , "masao.fujii@oss.nttdata.com" , "andres@anarazel.de" , "magnus@hagander.net" , "mark.dilger@enterprisedb.com" , "don@seiler.us" , "pgsql-hackers@postgresql.org" Subject: Re: Estimating HugePages Requirements? Message-ID: References: <20210914.094936.565951707453489109.horikyota.ntt@gmail.com> <20210916171427.GR831@telsasoft.com> <4E144FAA-F3B1-42C3-9748-714ADB4BCC22@amazon.com> <3E81D643-0759-4373-BEA6-5BF8818710BF@amazon.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="ZtHVUyma/QPixUsS" Content-Disposition: inline In-Reply-To: <3E81D643-0759-4373-BEA6-5BF8818710BF@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --ZtHVUyma/QPixUsS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 21, 2021 at 12:08:22AM +0000, Bossart, Nathan wrote: > Should we also initialize the shared memory GUCs in bootstrap and > single-user mode? I think I missed this in bd17880. Why would we need that for the bootstrap mode? While looking at the patch for shared_memory_size, I have looked at those code paths to note that some of the runtime GUCs would be set thanks to the load of the control file, but supporting this case sounded rather limited to me for --single when it came to shared memory and huge page estimation and we don't load shared_preload_libraries in this context either, which could lead to wrong estimations. Anyway, I am not going to fight hard if people would like that for the --single mode, even if it may lead to an underestimation of the shmem allocated. -- Michael --ZtHVUyma/QPixUsS Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmFJQ3MACgkQnvQgOdby QH19WA/9HA79/sJJXptbcWefRN5ZC4endUyucuQ84Z1XXqKcZExG6xOPhGYkPbqT 6TRB80R+n0d4iQXI9G2mw9qLKJ2tSK3HF3ophRXEcbv6mH0g0HDgB9VHKwJsEpjP np7rlaqBvXKDmZaRb9yRRKEyii//LmU8dVA/DC5K9NG0CWE4uyL48lthTbTKh4MO MDiqWIYCKtK0NtodGo26MgqPj6M6zm0GD9b9g89TGHCcCL9KZ3xW2CUkGh5Vra8r u0HhW4sK3xF9YHXPUEVLShQUko3sv3hxNLFmhhRR44Y5onSaEbUPnLJodQ8QwZjU baJm11PjkH+QsEh3pBq6zFuZagygpqipJ+kUCEqDlKUKnd3ySAYmoDAi6xTmOntv sIqolgLSzOG+5YScgzCEOfr2iCec7ndnnyI9y25V8cXdRSCivESXPZ8wRru4HnEx 6CR7wtmYbm/wgNWUnYOYYj3BtjQ5ZbmD2r2nl+tChQXUukqrk2c6VPhYELovkqFL Gbm0hlli6gYPj7mNMoRV+M1Dz7j051dt7FaH50xy51SgcfRWE/o7OMnoNfTO/FOg 86xeQtVEyB4L9tD6oN5FUzQOT2dkhciozmL6P7HadvR40u0C2K9R/qaJtg0vm1Xy o9hc6dWjvW19vzGluelxPy13k3GOvGjnKKOuFtiNEgSyknwuHTY= =ZXa9 -----END PGP SIGNATURE----- --ZtHVUyma/QPixUsS--