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 1jbRz6-0002yJ-OR for pgsql-performance@arkaria.postgresql.org; Wed, 20 May 2020 16:54:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jbRz5-0001FK-J1 for pgsql-performance@arkaria.postgresql.org; Wed, 20 May 2020 16:54:23 +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 1jbRz5-0001FD-Bt for pgsql-performance@lists.postgresql.org; Wed, 20 May 2020 16:54:23 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jbRz2-0007J4-Q0 for pgsql-performance@lists.postgresql.org; Wed, 20 May 2020 16:54:23 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 640EB5F79E; Wed, 20 May 2020 12:54:19 -0400 (EDT) Date: Wed, 20 May 2020 12:54:19 -0400 From: Stephen Frost To: Piotr =?utf-8?Q?W=C5=82odarczyk?= Cc: pgsql-performance@lists.postgresql.org Subject: Re: OOM Killer kills PostgreSQL Message-ID: <20200520165419.GH3418@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="G44BJl3Aq1QbV/QL" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --G44BJl3Aq1QbV/QL Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Piotr W=C5=82odarczyk (piotrwlodarczyk89@gmail.com) wrote: > We met unexpected PostgreSQL shutdown. After a little investigation we've > discovered that problem is in OOM killer which kills our PostgreSQL. You need to configure your system to not overcommit. Read up on overcommit_ratio and overcommit_memory Linux settings. Thanks, Stephen --G44BJl3Aq1QbV/QL Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJexWC7AAoJEO1sijiDR2RVz+8P/iq2XmMt83EbgsrDIiBfTe7i 4rRI1/DfS5gsOrcMV1+h8AHZSBwDpd6dtMZd+0mBryz7oh0cbkiQZc4LhFqtsNBU Pbd0uYEo9MohHKcIOlhotolCl3tPejjciGC4AJzEqZMexxhPYR+LWezKSN5SlMHb g3/5GyfTROQ2ZcdrJJGOBEiORAJsC8ZCmYoQWlBn95Eo53vDqBXcmTU87moiJfKv JluX6at+cXfwmq28pqIhFb71o1Ic1BySkdJbop9XjRO4tNUJdKCw0Yy+E1JM4Raw +X1pGcRJIxNOU5lhdsOuPlFwNHQqPODT3BRGAH417F8wq+gZB2lra0M7brCivcxl 69bwNOjgZ5g3CPY/7yUV1QOgIkrmoPJAbA1C3zR06jczixZ1lHeSRmxh+p2EFv5T TSuqWbbjImpjZ1B8lPNABCb3Mqq8VC4lVbVsCXFEPf21R8tXZ6FGDLBv5FLdd8ws kFoLhM0nMNbEvXVhGwufDDtWNFSY6eRw6WyJWX5fewHB7Kdqx6Kyt1rGOAaEQ3hw 495upSGSoaIoRxHVilmM4VQZICUyuqh+g5Dp9BCQ/H5+z4RbFToagJMad7+lvD47 hNYqa6gUhdCVI3Zf1bCQbBon1LjBB1ceXn+twGoBpJhB5cEmJ4bNHjymXcc1U+By xRD5upn6k2tMiKTvxFf1 =gHJL -----END PGP SIGNATURE----- --G44BJl3Aq1QbV/QL--