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 1mMFgY-0001T3-SG for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 20:21:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mMFgW-0002hR-SK for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 20:21:12 +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 1mMFgV-0002hJ-3N for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 20:21:12 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMFgO-0006Zf-2b for pgsql-hackers@postgresql.org; Fri, 03 Sep 2021 20:21:09 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 72CB15C0130; Fri, 3 Sep 2021 16:21:02 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Fri, 03 Sep 2021 16:21:02 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=o9h3N9SDwLpZtMH9IiR94KKoDzk elYkDwgdURr5f/9g=; b=hAsJsKKrIutxuGlY8wN2cn2XnCzKb1Ym4VhF4uzrxbu KPl1Hkm4UN0pPOzq2eAnj00LZSjtVzSj3v6QWi8fBiFxZLwPTooSiWnjkBmTbrnE vqfvwbkLEyWfWD3R499/IjI3N/GixfTlcDQdEe0LsiCzHKJz/oM66KDZm0MsrgHB QmqcVgG4g3pMfdbYC3WHHpNWzXwHfBKazWoAKv53YBkhHRrVKqH1jPb5OpJdt/Jh hgVpovPjpXmxEJiG1+jp8pMjQlyvcmok7ism/KE1syP73iBg5cwlovPdxbgAnrGs 5cK3DbfTOyZFBvUO2GpEPhiJF1oGnvf4E6275Fy7UQQ== 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=o9h3N9 SDwLpZtMH9IiR94KKoDzkelYkDwgdURr5f/9g=; b=OAc0S+r2Rzzr2xh/byepPY XZQLdRzW7o+GAxRkkZGBjoPWdJF4+KVqpzWU9ciPBkpd/qCRNOkzJ4BjY+KCGSec IY0+PCxbMxzT+jiFAdxl6MfMu9hjGKQ+hC4DlKZVHehTwLCHB35+dS320m53hqvF lz+fO72T4b4iyAgNt+0yRF5gqFYOYq2sLN6idYgnj8vKeTmFpAGHxX3pJ0+rJl54 LvtuR26HLem/MsygTZ12CUzm3TzxQcSZi3ZKRkokPASFiap9xrbZ76uetFDdaCYN +8rdD/pb4k/8v0ONmIVKoTCvkmXA6w/jDs7kJyf3Ma4MfVfxN19UWBT1ReOF3f9Q == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddruddvjedgudeghecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrf grthhtvghrnhepudekhfekleeugeevteehleffffejgeelueduleeffeeutdelffeujeff hfeuffdunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 3 Sep 2021 16:21:01 -0400 (EDT) Date: Fri, 3 Sep 2021 13:20:59 -0700 From: Andres Freund To: Michael Paquier Cc: "Bossart, Nathan" , Justin Pryzby , Magnus Hagander , Mark Dilger , Don Seiler , "pgsql-hackers@postgresql.org" Subject: Re: Estimating HugePages Requirements? Message-ID: <20210903202059.lmtc67pivexfmj3a@alap3.anarazel.de> References: <20210827184648.d3jbv73pgyccqwkz@alap3.anarazel.de> <071DC95B-4CA8-4D2B-BD24-1A66B3EFFE28@amazon.com> <20210827193813.oqo5lamvyzahs35o@alap3.anarazel.de> <0D1645F3-ADFD-4B2F-9F34-961BDFBB881B@amazon.com> <20210828035722.GQ26465@telsasoft.com> <82E1E183-691F-479E-B661-9BE8EC70BD21@amazon.com> <48795AC4-289F-4CDE-88F5-4FD1ED2BD3DD@amazon.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2021-09-01 15:53:52 +0900, Michael Paquier wrote: > Hmm. I am not sure about the addition of huge_pages_required, knowing > that we would have shared_memory_size. I'd rather let the calculation > part to the user with a scan of /proc/meminfo. -1. We can easily do better, what do we gain by making the user do this stuff? Especially because the right value also depends on huge_page_size. Greetings, Andres Freund