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 1qHS1b-0000Fn-4l for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jul 2023 16:40:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHS1Z-0004sx-Oc for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jul 2023 16:40:09 +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 1qHS1Z-0004so-E2 for pgsql-admin@lists.postgresql.org; Thu, 06 Jul 2023 16:40:09 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHS1W-002ZgU-GO for pgsql-admin@lists.postgresql.org; Thu, 06 Jul 2023 16:40:08 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-56fff21c2ebso11286937b3.3 for ; Thu, 06 Jul 2023 09:40:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688661605; x=1691253605; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=ndwRirCHJRfhBYmYZqGo0pzwJrlaZjCMP/2RL+ygOLc=; b=KENp+n2CyL6DO9Ob8+mnltk4Y66qrwn9Ia9IYTHPIRSJK1EOMpuTDywpuA/RiFOtYn Wwuks2DuKa0dHIanniq+jvop05I43e6uUv2QaDvaUnN/TNGTT6ikdNQAmGfmXT9RdKXw vF0MnhgytWWEIdo6Wvp+YI3q+VQ4cT301EaOqsGzKNi4eZEge6GjapuXXoCVHd24r38D KPopG/aPiYpB/fGrgG7tWNarin+y0vhN13m5iDaocspEutypb+vv4LBtSV2bmRLAgE2D DiRuUixgoKaJrVtoEclnctWGrAj8KWpB3O4DKxiSfOfxmCt7bGXqP5o5F/zNwiHs6aqY 4J2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688661605; x=1691253605; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=ndwRirCHJRfhBYmYZqGo0pzwJrlaZjCMP/2RL+ygOLc=; b=CHj2Js4o1vZaDjxRFX8nOzqJreKolVGrkdhe/XQQNW2ofqxJlv9c8ccnSR3P8fHclp C8yXq57BRzGb2C95C3pQZhKKus1L66n/AA8R/agLYJqvGnjN8nw2xgFA1+ASAsNanfZ2 wN2VxLV3PGOgg8q0mZFacxBij8ibIJWS5/cRx8Eb0k+GhcRe/FTsSiCIftz2lx9NC4QQ JdtKb9C+tBul+5riqZKsz3Fl5s/7WnOqLfZW3nDYCZYHNyVJiZTUHsxKt0cCNaKR7qWX xtl1n+mSIMdWzTBOW08Q8aWPQ+ATvvibv9F+f1mnSRWW12dc5btogaQwxW7xH6FDMh+/ gmUg== X-Gm-Message-State: ABy/qLat2s6nX1lHwwGRcO18Q2EEYadAuzZ0DlxEiY6l/1RXO5h7TC9o Kcfb2eAtgs5npSUyF7+8bIqr6jUs4SE= X-Google-Smtp-Source: APBJJlFd6bkLu59sRSvEYUZweYfAX+A9WHYL4lKPorIPKW04tLB4V4pITcB6ONtQFqCT7kt8JfqNGw== X-Received: by 2002:a81:de51:0:b0:56d:2e22:8b31 with SMTP id o17-20020a81de51000000b0056d2e228b31mr2532551ywl.41.1688661604761; Thu, 06 Jul 2023 09:40:04 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:5dc9:ed67:de4:7330? ([2600:1700:bd2c:b810:5dc9:ed67:de4:7330]) by smtp.googlemail.com with ESMTPSA id b127-20020a816785000000b0057a44e20fb8sm452634ywc.73.2023.07.06.09.40.04 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 06 Jul 2023 09:40:04 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------bcVW1303LBr7gY3H8mpmQsGM" Message-ID: Date: Thu, 6 Jul 2023 11:40:04 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Invoke OOM killer Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------bcVW1303LBr7gY3H8mpmQsGM Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 7/6/23 11:27, kaido vaikla wrote: > Hi, > > How to invoke OOM killer for pg process? > Some easy "hack" for test purpose. > > OS > Rocky Linux release 9.2 (Blue Onyx) > pg > 15.2 https://www.percona.com/blog/out-of-memory-killer-or-savior/ I'd run "wapoff -a", set vm.overcommit_memory=2, and then run a simple C program that mallocs a /lot/ of memory, mlocks it and then fills it with FF bits. -- Born in Arizona, moved to Babylonia. --------------bcVW1303LBr7gY3H8mpmQsGM Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 7/6/23 11:27, kaido vaikla wrote:
Hi, 

How to invoke OOM killer for pg process?
Some easy "hack" for test purpose.

OS
Rocky Linux release 9.2 (Blue Onyx)
pg
15.2

https://www.percona.com/blog/out-of-memory-killer-or-savior/

I'd run "wapoff -a", set vm.overcommit_memory=2, and then run a simple C program that mallocs a lot of memory, mlocks it and then fills it with FF bits.

--
Born in Arizona, moved to Babylonia.
--------------bcVW1303LBr7gY3H8mpmQsGM--