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 1mJVdb-0003qc-Qg for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Aug 2021 06:46:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJVdY-00081m-Eh for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Aug 2021 06:46:48 +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 1mJVdY-00081e-6o for pgsql-hackers@lists.postgresql.org; Fri, 27 Aug 2021 06:46:48 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJVdU-0006Qv-Te for pgsql-hackers@postgresql.org; Fri, 27 Aug 2021 06:46:46 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 63EC03200983; Fri, 27 Aug 2021 02:46:42 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Fri, 27 Aug 2021 02:46:42 -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=E/OCnwbVjWhFEclYI1ibJPsvHze q/zmJuNlcB7YYwFQ=; b=N1NgJbASjx8RdtkwABoIGG/AxpsyTdfM/2PYq+1Mea/ pzVQc7qyoUtaNQe/3EQWw0mYBzESopaM1nIB7GFSe4amw5PTPTc8MbJuoPecNHWa /bZxfWpUBEYOOohIaNsxgn5vAaqZRlXcoFj01iUDsL9nVqeprgfOIhhgNtLnSDOv tMmDh94fX61BjYtqJ1Ny51VMRQjd1hBaafkttnuQXIPfe5EcUHjGOTfKnEPvtvS6 TqD9y7s69likDDvqb8MQEzCEvyzBKhkesjxcUOtEh4aWjNAG2jiYvBENxE0ciOgk pKjwjp2g1w7EV4kuhzGInWdAXqFjXFaHXFRbKntoNGQ== 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=E/OCnw bVjWhFEclYI1ibJPsvHzeq/zmJuNlcB7YYwFQ=; b=csXJ7iZtOI/t/aqFxor9b2 r3dtTK5wlOGOJsdSvZQpV09o/7hpry//hxqi3lsTdKImw1szGgzYGH/W0GQRRVBK vcfPV8UEZy0Fr72r6bPWDI49FkVaxBNGHToW3Nn3u9k/ldrikTxiu1yjW1RgYtlp MZ8ZQ+lGdaVzmY/KBYrFbva53ch/fmmUG8QVV1kegjmu97PcI4KwkFYB4542NkBe ufnofmxJDL20TemPSpwmN5Lbxe5SNwO4zrUElFExn3FR4q1X/3yImv3eKONOs8ss XHTl6nVzgKIHUidkbkv02mdZs91rMylKDjpezRCoY7L4MYruaqtQ9yJvk5sgUWtg == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrudduvddguddufecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveej heehieevueeigeelteegleejleeiueeiheegvefhnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 27 Aug 2021 02:46:38 -0400 (EDT) Date: Fri, 27 Aug 2021 15:46:35 +0900 From: Michael Paquier To: "Bossart, Nathan" Cc: Andres Freund , Mark Dilger , Don Seiler , "pgsql-hackers@postgresql.org" Subject: Re: Estimating HugePages Requirements? Message-ID: References: <73A4E25F-1039-4FC9-8E6E-0A00230BDFB8@enterprisedb.com> <92BB93C3-1AA8-4548-96F7-062C4AF09182@amazon.com> <20210810034205.r72j5uouynepj4f2@alap3.anarazel.de> <0545F7B3-70C0-4DE8-8C85-EAFE6113B7EE@amazon.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="nhViOVLStjyF9lZ8" Content-Disposition: inline In-Reply-To: <0545F7B3-70C0-4DE8-8C85-EAFE6113B7EE@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --nhViOVLStjyF9lZ8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Aug 11, 2021 at 11:23:52PM +0000, Bossart, Nathan wrote: > I think BootstrapModeMain() makes the most sense. It fits in nicely > with the --check logic that's already there. With v3, the following > command can be used to retrieve the amount of shared memory required. >=20 > postgres --output-shmem -D dir >=20 > While testing this new option, I noticed that you can achieve similar > results today with the following command, although this one will > actually try to create the shared memory, too. That may not be the best option. > IMO the new option is still handy, but I can see the argument that it > might not be necessary. A separate option looks handy. Wouldn't it be better to document it in postgres-ref.sgml then? -- Michael --nhViOVLStjyF9lZ8 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmEoiksACgkQnvQgOdby QH3Cqw/6AiQdhE9LFHA1OOQluKP7gpBwGjyffcp0nVinR+26VSUe3enrNQyD5c5K FKBQuzjvfCyQneGFaB8B4PRvNKD7Y7lX5I8Q/BTPjLDA5+VyPBDQb0rrNh1oH1tT esEwwRELM7ufBXwluHRZXTAlQuQ/cy6o7STgL3miQGi05VapheT+OIHzZnpVGpKq LVPloECUmmp4ck8/EAis3EqTxPxpjgUPr6d5GKJ0k+lPNB/u/JAiBB7XEbYpD08C PSIdB9ac8AZfWR+plf34fo/ckuLNI9DOaV3hrJ3xsxbaE6ZkaX0qmIwx3lz7Fjks pPajnVIjWudjuHYVikXkgLpwNiNA4ygumVErZelDMEfopNrRklOr2Ha7gcsVwTQ4 XBfnsK/g6jO8sk2T8Pvv3GGjWCzc7ZuXBxiJxfR9H0DOAw3woyqnbYzgAzQYXw3K 41SyBv1L4opL5dRyLfi6sC36/2T0AwuZPEOhBN1CcgT5xKgMIeI+WM1nbTkL1i/o dQ86rHIeU5ZEe7E6HHARaPXtOBvQ7Dabru8lVDfdNiaTFG+5wnNKTCoXvPaQsbd6 klf+crS8etRKWjXJaA/E+CpTihb4/cXtJ7kZ0jKRIa9EnS1Y7+jbbtgdMhOzuj5P v6s7DEYPXY+AU9aKmLZKqbwdXwhG2IwsRUHn2+AuwPgWADBWUSM= =p0/R -----END PGP SIGNATURE----- --nhViOVLStjyF9lZ8--