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 1mStKL-00056W-Hb for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Sep 2021 03:53:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mStKK-00049o-Ek for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Sep 2021 03:53:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mStKF-00049f-EM for pgsql-hackers@lists.postgresql.org; Wed, 22 Sep 2021 03:53:44 +0000 Received: from new4-smtp.messagingengine.com ([66.111.4.230]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mStKC-0006iV-G3 for pgsql-hackers@postgresql.org; Wed, 22 Sep 2021 03:53:38 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailnew.nyi.internal (Postfix) with ESMTP id 5474B580491; Tue, 21 Sep 2021 23:53:34 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Tue, 21 Sep 2021 23:53:34 -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=TegN30duOiOA6HogAMT/nU33fJX ncKWucMFteWGxqNo=; b=K30JV8KHXNLoeSgskoj2iSBC9UZ/5ExMasOO2k88nu8 JmYfZviOaxYgyK3v4nhvJgB61nuk8+JawvzO9joP1Hyy9TEgQV5a46jUfXjexLe5 V4FRu+QP1AAWfoQujtlWX3nYY35+YQ6Ee5kwrOqNseyxsidlXotveMfAhIq1Wt0f vjeF4nQRSlRMIv/zH9RnCo/fk0cbYOsISOk6JdLL6fXaRmGf56Cweb25duOHbMJ1 4AgzCkHfjWnjzINf1HDkcQ5aY4XcvyKQD5Pdjfpoln+PuMgBa1GaUKLzfDn7dTQC htEZzJ09c5XIRf25kcQCFAoXo6hAJ9aoaJoUIQGcQZQ== 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=TegN30 duOiOA6HogAMT/nU33fJXncKWucMFteWGxqNo=; b=rdhFIr79IjaOBrh0lwc8V6 sd5Q6FJQHCL+bGXSOpjJQFGL13vg0KDbDcH3Q7BhCXnxHrx6W2aMmOm4+3oDjVzH nUf28yEF5v/EyHseSK2eWGrxUhucJXmaH635uTDMEjOwBIKPrREn7okWWHj75RfS e91OnjrfG2mbZipxM+dmz9FCysCQkH++IBFj6FOxhzvxCEvCYRLhtrNEC+6f9VjH 4h17OrBTVXLlgOPeJPKmKwU94FqjORpPN285WMdWLst/P6eNylP/C9HcO62P2EV/ I3+qdNWf6Glf2dQLw8/xkqLomZIS8BQRugApa/iHGtbmlfCw1WQk2MnBBFxiKnTQ == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudeiiedgjedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 21 Sep 2021 23:53:30 -0400 (EDT) Date: Wed, 22 Sep 2021 12:53:26 +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: <20210916171427.GR831@telsasoft.com> <4E144FAA-F3B1-42C3-9748-714ADB4BCC22@amazon.com> <3E81D643-0759-4373-BEA6-5BF8818710BF@amazon.com> <38A91A51-F041-4ED6-8A8F-6A0D3D38E756@amazon.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="67JGsonP2k8d4go6" Content-Disposition: inline In-Reply-To: <38A91A51-F041-4ED6-8A8F-6A0D3D38E756@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --67JGsonP2k8d4go6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 21, 2021 at 04:06:38PM +0000, Bossart, Nathan wrote: > I was looking at this from the standpoint of keeping the startup steps > consistent between the modes. Looking again, I can't think of > a strong reason to add it to bootstrap mode. I think the case for > adding it to single-user mode is a bit stronger, as commands like > "SHOW shared_memory_size;" currently return 0. I lean in favor of > adding it for single-user mode, but it's probably fine either way. I am not sure either as that's a tradeoff between an underestimation and no information. The argument of consistency indeed matters. Let's see if others have any opinion to share on this point. -- Michael --67JGsonP2k8d4go6 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmFKqLYACgkQnvQgOdby QH0jgw/+P2AFxDJc53pqjDVNuC7U7FRHUZKtWebYVe1piAU1fXB8tqlncohAHtlY u42WctE2MOMD24GgMeUBKTYC/yIg8/g1ewL49qxO3vJ2xwlxQ7KxO7tlkP9e09jc vh+1jEj6Ej2PJOfyvae++e2gYh/cuAd6MfJacCXV7JLdyrhNSTvVm1/t0MNlx9zZ 6r6IyxGL92wlguj08q2vKBaGV89bWdVnVe20MqMGkNezVDRfTNbBBQlBJG66jl65 SYC1jcPItSEQs9+xkoWO0zjW+ygOPuCxgZEmXKu3AF68iID4MZF1l3Md3E/Zbt6Q sQhwlLRizCYUPJICzmhL9yz+E3dwJuchxO76tHAq2q/tTocJFiVJAcm8eK7YWDrH M9HdDumZudx/8Qv2+RJTU9FETZFV0/hJRRfgC43fGsVRl+FQXuP0ZfviRfldKq3D zsqQZ+Zp8Wl62lndAsRkRBKi18g5zb+91H1eyUFlw+1geadiS1xKyoJRqOZDilFn 6PQhoyjSLBZgxW9A8XAYrZEZni+agUTSWjZgFN2nRAPBr3uTE9e5Y3xoWFyOAJhm kADyi94sIHaxZZksqqcFwwoeVtiqEjYWdZKp27ou+iKRoFw1UkbVJ6yfagme5UyY a1606n4XL2bKo6vQYrswcT/p2bHamefjziL9xi3v4xuDCp+OJ0A= =o1t1 -----END PGP SIGNATURE----- --67JGsonP2k8d4go6--