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 1lrbFP-0005MA-LF for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jun 2021 07:06:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lrbFN-00041Z-4h for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jun 2021 07:06:29 +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 1lrbFM-00041R-Lw for pgsql-admin@lists.postgresql.org; Fri, 11 Jun 2021 07:06:28 +0000 Received: from truschnigg.info ([89.163.150.210]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lrbFF-00033A-Vs for pgsql-admin@lists.postgresql.org; Fri, 11 Jun 2021 07:06:28 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) by truschnigg.info (Postfix) with ESMTPSA id 9C85220182 for ; Fri, 11 Jun 2021 07:06:19 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1623395179; bh=saIoqR5yhD9JNgu5z4iC3YxF9fqT4Ny5XpIw7sgwKxI=; h=Date:From:To:Subject:References:In-Reply-To:From; b=Cdous0oTMe4rPY1mjX7yPWUYd4M0r+Tk9Bkynv2/TEMIX9bO/I8vUKuisiwUvs3/W WqFWucXtrLJzmQq2LJi/uGXH6VnVRq4IlUg0mAVBVfIYNqb7WAQgo9Z90KQGAn7OE3 X3FJ9Ks5QC3C3jFpnQm0v1T3wIlGVznEMKJRid4w= Date: Fri, 11 Jun 2021 09:06:17 +0200 From: Johannes Truschnigg To: pgsql-admin@lists.postgresql.org Subject: Re: RHEL-8 Kernel Settings Message-ID: <20210611070617.GB5793@vault.lan> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="uAKRQypu60I7Lcqm" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --uAKRQypu60I7Lcqm Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jun 11, 2021 at 08:56:13AM +0200, Laurenz Albe wrote: > [...] > I recommend setting > > vm.overcommit_memory =3D 2 Be careful with this though, most applications no not allocate memory as thoughtfully as Postgres - so if your server is running any other kind of service/software in addition to Postgres, you should make sure that can survive Linux not overcommitting like there's no tomorrow, too. --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +43 650 2 133337 xmpp: johannes@truschnigg.info --uAKRQypu60I7Lcqm Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAmDDC2QACgkQ95W3jMsY fLV47Q/+MvzAv9aXMZEGVZCTnsG5fosP9yCEJ2E0/tGgxO+WVXh6s6WPe2ZEm3qB YtEQAQkuljFbGexUmWK/RvE5D0zSFqttth0f5X0W7Qt6h4FpevxH+cDZ+TO5iQGk zCqiKC5nmcOJzAxfB435drupjxBZT4jZrGauKMx6ucjvw30va+Wa7WvQeJ4NhUvv hmlFH4wj5ZZ6qhRPH2Yc2WPdNxkDHxWP2xwnK8NUtxya7Ht0HemGuAavw/8R6TeU ui0zPepASkXJGjIvOeBqSnoGfDNX6rB4jLKNvi+x3249BKJhYP5EfmHgQmMKB0Og XRncB9VR22hQDhceAAiYKrGleUaflyiiLHl/1LoGY0BSReG/Eo9HAqTWAN/MmwpR YgkwhE1omSEyDf0/SEj3TazPuG6e457oAjrg4NyIyd//6xrJ6PMZHmdhSAU0pai4 tcd74OHrqKXDk2AWSqbU50DH7cCSdaGT8pZS6I8YyxjGhYUxwW3HTTqdhoDnQMr+ auMmQubxa5XNz6vYVw12Q2XzIjAVkZ3di6b7faZde3rnQmhI8s6X2LgWv9ZzHhNP TErWdNjopbEiAoY1cwA8J8Cj9TUczDSQmkfveCleRAK1BY4snnTZdH+PEEACKPuO NswXjqhM5UpjVqYlx5VRkueBubHffp33njkHeoNd7r6aQ08pDas= =3kMl -----END PGP SIGNATURE----- --uAKRQypu60I7Lcqm--