Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1YXO-00GoX3-Gw for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Oct 2024 22:00:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t1YXM-00AoAS-U4 for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Oct 2024 22:00:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1YXM-00AoA9-Kd for pgsql-hackers@lists.postgresql.org; Thu, 17 Oct 2024 22:00:04 +0000 Received: from mail-io1-xd2e.google.com ([2607:f8b0:4864:20::d2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t1YXH-001QrF-Od for pgsql-hackers@postgresql.org; Thu, 17 Oct 2024 22:00:03 +0000 Received: by mail-io1-xd2e.google.com with SMTP id ca18e2360f4ac-8354599fd8aso59863339f.1 for ; Thu, 17 Oct 2024 14:59:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729202397; x=1729807197; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Ekrp5EpxMNBFdjx+drmQIRCA7nI2gsrj0+1tH4P+/D0=; b=DK4c76cUmCjnsb2ZbCZV9NARFyBmR3F/cwi9jmeXeCj9KbwXq084bSE0vAaLjeyDyn BeWT3L1Albpt3dnW1uYyMgN1O2CsXNvw1tGd4Al9ltRGnonKW3X5rVDTT9pbzaz8RIZa 6rKG5q7ARSW/dI276vzGr02qTOo7Ij+i9ujApuLO/MroFW/Z17ByfINRblXbPG4ZdoCk 7pFNYnd05+2t9z7P5uLptHrJNVF2O5vMl25C4Gdz2qZISInDu0ZnEFJ+qsQX3Vqg6Wtx tr14JwFt4ppeGb81JAW/pfuDkK9rOWCetXS3KcoOrABmZ0xVJGAykz6Y3eISJAI5+3Bm dkpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729202397; x=1729807197; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Ekrp5EpxMNBFdjx+drmQIRCA7nI2gsrj0+1tH4P+/D0=; b=HtTkD1U8T5sLXiJ/nSQwO9aKQs2wi7CzRJW/iG2IqeEq6CKSnONZinPTGfSLWRmMaj MUF+IFZbrxq5h6H9D495xmpnHZXVicbQsHy1jL6ZrVDgmOeRjDz1Xvdef+oLyqybTq9N fw/5B1/sPMxZQ+4eNfR4w/cKjKn6O4XmOyuAFFsigcb0RfNkl9C1kPCI5HwDQZFo1290 t+U2hOSBhjmARYjGK+6j7Oq8WFGSTL5YOTzk9Cqc9KiUMfIB4khtbyB4dfX7UpY1kr70 PqgPOSr1k3kJaEINrc0Y2wPWV//rRhk8oAW6BiYNO7j3+e9tM3kaZ7qciWkS0EKIy0Zx Nqew== X-Forwarded-Encrypted: i=1; AJvYcCV5s888DCEykQUuvifIrytQZnWjN1s+1UqiG9Kpa88+CEzVzLaKYpTQmtIJ/Lhtik5LCtHxx8oC6vERaTDk@postgresql.org X-Gm-Message-State: AOJu0YxZ18005x0kPQAQgNaDkRTAa1ynIws4FX2pr6QNxiFM4vtoVvqQ y3aZfXHjHDYtybq6JyZSWbfhnefGjgxv6WsgkVjAMCZqf4nR+F9/wEr7gg== X-Google-Smtp-Source: AGHT+IGj/5N9lcmvVKk5gmt84SjKz8zwF3EliSRRaSMfaWQrY5VpLWVSvnMiemLYwOT3JY1Nd9CZXg== X-Received: by 2002:a05:6e02:1945:b0:3a3:983a:8741 with SMTP id e9e14a558f8ab-3a3f4073dddmr2330475ab.11.1729202397355; Thu, 17 Oct 2024 14:59:57 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3a3f402e0efsm486375ab.57.2024.10.17.14.59.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 17 Oct 2024 14:59:56 -0700 (PDT) Date: Thu, 17 Oct 2024 16:59:54 -0500 From: Nathan Bossart To: Seino Yuki Cc: Fujii Masao , Michael Paquier , pgsql-hackers@postgresql.org Subject: Re: Doc: shared_memory_size_in_huge_pages with the "SHOW" command. Message-ID: References: <420584fd274f9ec4f337da55ffb3b790@oss.nttdata.com> <755f74a1-d50a-4411-aed2-d8cf09764865@oss.nttdata.com> <5bdb7847bf2bdefc84b11cc89cbd5aba@oss.nttdata.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="lUHZUC13nOf461/L" Content-Disposition: inline In-Reply-To: <5bdb7847bf2bdefc84b11cc89cbd5aba@oss.nttdata.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --lUHZUC13nOf461/L Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Oct 17, 2024 at 02:07:32PM +0900, Seino Yuki wrote: > I've fixed the patch and will register it in the CF. Thanks. Here is what I have staged for commit. -- nathan --lUHZUC13nOf461/L Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v3-0001-Adjust-documentation-for-configuring-Linux-huge-p.patch" From 8aff8ec54a6588614f952693f509b75bf240851c Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Thu, 17 Oct 2024 16:56:52 -0500 Subject: [PATCH v3 1/1] Adjust documentation for configuring Linux huge pages. The present wording about viewing shared_memory_size_in_huge_pages seems to suggest that the parameter cannot be viewed after startup at all, whereas the intent is to make it clear that you can't use "postgres -C" to view this GUC while the server is running. This commit rephrases this section to remove the ambiguity. Author: Seino Yuki Reviewed-by: Michael Paquier, David G. Johnston, Fujii Masao Discussion: https://postgr.es/m/420584fd274f9ec4f337da55ffb3b790%40oss.nttdata.com Backpatch-through: 15 --- doc/src/sgml/runtime.sgml | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 2c4d5ef640..a47fa67b38 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1429,11 +1429,10 @@ export PG_OOM_ADJUST_VALUE=0 with CONFIG_HUGETLBFS=y and CONFIG_HUGETLB_PAGE=y. You will also have to configure the operating system to provide enough huge pages of the desired size. - To determine the number of huge pages needed, use the - postgres command to see the value of - . Note that the - server must be shut down to view this runtime-computed parameter. - This might look like: + The runtime-computed parameter + reports the number + of huge pages required. This parameter can be viewed before starting the + server with a postgres command like: $ postgres -D $PGDATA -C shared_memory_size_in_huge_pages 3170 -- 2.39.5 (Apple Git-154) --lUHZUC13nOf461/L--