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 1qg4y1-00EOUM-NA for pgsql-docs@arkaria.postgresql.org; Tue, 12 Sep 2023 15:06:18 +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 1qg4y0-009QbG-K7 for pgsql-docs@arkaria.postgresql.org; Tue, 12 Sep 2023 15:06:16 +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 1qg4y0-009Qar-0q for pgsql-docs@lists.postgresql.org; Tue, 12 Sep 2023 15:06:16 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qg4xv-004AOH-S0 for pgsql-docs@lists.postgresql.org; Tue, 12 Sep 2023 15:06:14 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 30EFE5C0045; Tue, 12 Sep 2023 10:58:10 -0400 (EDT) Received: from imap49 ([10.202.2.99]) by compute6.internal (MEProxy); Tue, 12 Sep 2023 10:58:10 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1694530690; x=1694617090; bh=CR p2z2dHP85sY2ypCmR9sBtwGB9NMtbR9u5KJOWCTSs=; b=kgaOa9kKaIvH4K3RhR dOEAa2HaOXTbspsaoYA/8YJL7ijWyrMjdtzzQEdczRMnjYNaLGvfGl+fjRFCU+dG 9BPMZiL0zLc6lpRXPkX1JFW3xpYn/+hRe68Sq1zxVnXqxoCLVUyzPgpfwDoskRME Y4msMPppMotTSjC6ruePubqEfiVTrxh8mE0gnanf1UaslOeeNoXfKbAvyRw2SZPY v+8MgW8Q3Jnwc6OOrxdpEF+3eAixuTQkiMSgqaYTlZVSmI2Yzj4TZXYdS0ki9gRU ETLx+0os9YoTn6Bb00hiKDUyTHe+pKTuIvPndnoDvywMtCDyfTdjZjVShK2NwbHe w/vg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1694530690; x=1694617090; bh=CRp2z2dHP85sY 2ypCmR9sBtwGB9NMtbR9u5KJOWCTSs=; b=VkaIzwT1fO49asYhrS8J8wXGKSgGM NoDnr7pAlif4QbJtU5iEXjnWdiHjKuiKVuFlQkl6cntlokIpLdZJddzj2gpColXn tjDHOS0orPVPjtrx3KNTLmwMiXjqtGGdGyGGL9/AT2PtRFh6THU+0c2SzK3ejhRV +b8UJxgyaYp41IFnrE7/IFFgLrUJTrNostb7ZdtEdzk6UNEtLzJ9RWgs80FiEYTJ HWi+WNutdTbo1lGHashMzv9+f64CRKIPueNjnWpgjjl0kyhXRHvaAMIzTqfDvFQV rEmEwqBIUvGfSafykDO6slP+lZ6JomkHTX0jcPZ9LSQgRks38hVYrR2kw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudeiiedgkedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefofgggkfgjfhffhffvufgtsegrtd erreerredtnecuhfhrohhmpedfgfhulhgvrhcuvfgrvhgvihhrrgdfuceovghulhgvrhes vghulhgvrhhtohdrtghomheqnecuggftrfgrthhtvghrnheptdfhgeevfeevteevgeeihf fhteekhefhheeiieffkeehtdevgeevjefgudfghfdtnecuffhomhgrihhnpehkvghrnhgv lhdrohhrghdpphhoshhtghhrvghsqhhlrdhorhhgpdgvnhhtvghrphhrihhsvggusgdrtg homhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegv uhhlvghrsegvuhhlvghrthhordgtohhm X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id CEF3715A0092; Tue, 12 Sep 2023 10:58:09 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-745-g95dd7bea33-fm-20230905.001-g95dd7bea Mime-Version: 1.0 Message-Id: In-Reply-To: <169412055867.2433965.4920921275706057547@wrigleys.postgresql.org> References: <169412055867.2433965.4920921275706057547@wrigleys.postgresql.org> Date: Tue, 12 Sep 2023 11:57:49 -0300 From: "Euler Taveira" To: patribuni@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Kernel settings shmall Content-Type: multipart/alternative; boundary=9212b0ad1a4f405ea7a3d9d8546c9121 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --9212b0ad1a4f405ea7a3d9d8546c9121 Content-Type: text/plain On Thu, Sep 7, 2023, at 6:02 PM, PG Doc comments form wrote: > The kernel parameter shmall is only in pages in Linux but your documentation > says it can also be in bytes. Maybe it's in bytes with some OS other than > Linux but the way it is presented in table 18.1 is quite misleading.. Could > you add "depending on the OS" or something similar ? Many colleagues using > Linux think it can be in bytes with Linux. Could you rewrite that part ? > Table 18.1 in chapter 18.4.1 > The information is accurate. It says same as SHMMAX *if* bytes, or ceil(SHMMAX/PAGE_SIZE) *if* pages and the Linux documentation [1] says its unit is *pages*. You can claim that you always need to check if it is pages or bytes because you don't remember. I'm not sure if changing the order would be better because most of the supported operating systems use pages as unit. Is there any supported OS that still uses bytes as unit? Linux, FreeBSD, OpenBSD and macOS use pages; I'm not sure if any of the currently supported operating system [2] uses bytes. If not, my suggestion is to remove the "bytes" part. [1] https://www.kernel.org/doc/Documentation/sysctl/kernel.txt [2] https://www.postgresql.org/docs/current/supported-platforms.html -- Euler Taveira EDB https://www.enterprisedb.com/ --9212b0ad1a4f405ea7a3d9d8546c9121 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Thu, Sep 7, = 2023, at 6:02 PM, PG Doc comments form wrote:
The kernel parameter shmall is only in = pages in Linux but your documentation
says it can also be = in bytes. Maybe it's in bytes with some OS other than
Linu= x but the way it is presented in table 18.1 is quite misleading..  = Could
you add "depending on the OS" or something similar ?= Many colleagues using
Linux think it can be in bytes with= Linux. Could you rewrite that part ?
Table 18.1 in chapte= r 18.4.1


The in= formation is accurate. It says

same as SHMM= AX *if* bytes, or ceil(SHMMAX/PAGE_SIZE) *if* pages

and the Linux documentation [1] says its unit is *pages*.

You can claim that you always need to check if i= t is pages or bytes because you
don't remember. I'm not su= re if changing the order would be better because most
of t= he supported operating systems use pages as unit. Is there any supported= OS
that still uses bytes as unit? Linux, FreeBSD, OpenBSD= and macOS use pages; I'm
not sure if any of the currently= supported operating system [2] uses bytes. If
not, my sug= gestion is to remove the "bytes" part.

=


--
Euler T= aveira
EDB   https://www.enterprisedb.com/

--9212b0ad1a4f405ea7a3d9d8546c9121--