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 1oQVFn-0005Gp-BM for pgsql-admin@arkaria.postgresql.org; Tue, 23 Aug 2022 14:51:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQVFm-00046E-54 for pgsql-admin@arkaria.postgresql.org; Tue, 23 Aug 2022 14:51:42 +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 1oQVFl-00045y-QT for pgsql-admin@lists.postgresql.org; Tue, 23 Aug 2022 14:51:41 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oQVFj-0001QO-AA for pgsql-admin@lists.postgresql.org; Tue, 23 Aug 2022 14:51:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1661266297; bh=quDSkdJ9oCC1oZUNqA7CkX23LOcuxdb8NpxNExnRnjc=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=MhRCx0FPo26p8o1whFrJAWZOrOCapr2hfq4FO5/wQcGZLdDPQh7AiRe4BcEvJd7HH is0o93WZ4ayqYA8eyymDNKGOXYu5YxPPeaH6qsr6s0kNmaw3o+1411sjpm3TSPnRZi mLxpbnzOqcGpTnCx6L4PaaDVYLWFJGNiOkKiCgqY= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from alpha.localdomain ([93.225.222.113]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Md6Mt-1p0OEc0JHP-00aCt8; Tue, 23 Aug 2022 16:51:37 +0200 Received: from mini (tmo-116-181.customers.d1-online.com [80.187.116.181]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by alpha.localdomain (Postfix) with ESMTPSA id 0CC0E101458; Tue, 23 Aug 2022 16:51:35 +0200 (CEST) Date: Tue, 23 Aug 2022 16:49:08 +0200 From: Frank Streitzig To: Kenny Bachman Cc: Mladen Gogala , pgsql-admin@lists.postgresql.org Subject: Re: Postgresql 14 performance Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Provags-ID: V03:K1:jgkkm+AxX/g3vQtAtg4ZYF3T6f2liTI46KqFxvhds+4utRaFFUD mzAHAL5aD9YlMjVbaFFpolIqbGFJXrN7uGeA+tJ8TLOaxerxdoGQpfdG7lWsquBXeS7JhBA RBoOg830zQtBm6J5FtmCj9vZGwViK+k1dqT9WkFy+BeXsSPMhKCA56TuBLw3sGOUKRKeT0O J2Rfrp+Y/2BA6EY/dM3uA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:GfMEu1z15ho=:roGD/OzO1HlydW0snvNk5B 2zNHh+lslBR/XaHMU6GMYLlhEeOAv6pqhxwjx5049xkJOf7rrNhaGidJS5ywQQAiUW1p0kpXf pvUpmFFRRtnt+tbpP7LekxkRniLgD8HPjLTPa664X0E8ltjhS8jIDuJ333+EeQqV87w9cT2sH KBrm5Z5D6y4QxSnWSKfzbhIrdqpTG5WlCJSxwssWlgYEmUWqs9Ir7VSIlJ9qVJoE9C+mkBNJa FLUkqJBvWFANmsM7tvjR5tNdPHKRJSvDRhJrqe7lNZ62BYA4fyJ6JhA8eT4/AdXJG3Rfr3BJP k7H5ukEukigwYTvupYj357hsu8HTB0f9+NuJlJ9kIkpFYbYJ9FWcvggdy+U4wUnrNbK99Ddaa 3bIw1/YnrtO946noKj1GK7oM2i1rtin/TtGUTGJtYWVMzxER3WqB00dqa2yByxYVYzQUNdxFJ rzly6KtVfJHgrjHMRaV7XKRWE/eNZuEVmA98X4Rx1xq3BhZsnlN/xwkmCX/Z8kDVtrzwz3ck1 uGdM6jXk3LWipUOiy8LmKC2AfPhOoB0J2ugImNNOKcunpTArKkQSOhYWO5zTnb1aPrZ2Cc63n YbULv3d4oRI0/JdxL/WqbJC5Gwrg6AGJKKcsREEe32XwOu81K1Saq7dXX/w5ZtUj2Yw9fdTPk Chq+1uCTxPv8a91P+sgWNX1O69N8zeUzZTFs74wWG3jRjl85BCJ5hdX8tACnW57WhceJNJx6z 8xx4L3aPKbPupC9rU0/uQsM2dZBw5obHXGu3cB9bJWhcl/cJERAR1gxmUc2PJ/LeZy62aWhjQ UMX5AMW2boIeXoSVRvBMM+9H1LUBaG2TW8HGfZWczYPdBtuM396FD0DcuPFcL9ijraltGn9d2 J3j6CxY9IBe6HIqj7ZPNsQKI0O3NewkA77KIkkJQss8QOGhTlJBAK8gbt2XHdR92QuO3gRiZJ ZRnw67pDsmj7sOJHeqOHmKXnPfo7uzJrO+F1doVsUnD49bLRoBhGfQwOaAswuu5PByl7TE7CF AxnA97eYODj5Z7FiIMV8PYfunVFV0NfC3Qr/YDP/9ITwrp+l4llZkhUtVO+edRjc9ILKGHccJ TLS03WBdbDSFSqYz/7Uh5b2DkLqk823ReGGg504ineyT+84rkCq2THkgA== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Kenny, have you enable huge pages? See for example: https://linuxconfig.org/how-to-enable-hugepages-on-linux Best regards, Frank Am Tue, Aug 23, 2022 at 04:27:54PM +0300 schrieb Kenny Bachman: > Thank you so much for your response. I checked the huge page status; the > huge pages not allocated. > > AnonHugePages: 0 kB > ShmemHugePages: 0 kB > FileHugePages: 0 kB > HugePages_Total: 0 > HugePages_Free: 0 > HugePages_Rsvd: 0 > HugePages_Surp: 0 > Hugepagesize: 2048 kB > Hugetlb: 0 kB