Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: BUG #18675: Postgres is not realasing memory causing OOM
From: Daniel Gustafsson <daniel@yesql.se>
In-Reply-To: 
 <CAOn6LZr-ZZjMEbSDSoGZO_hPT7zhLJ-z9c_wPdizPAqHJtnaRQ@mail.gmail.com>
Date: Tue, 12 Nov 2024 15:56:07 +0100
Cc: Tomas Vondra <tomas@vondra.me>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
 "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se>
References: <18675-39a45505fb472bf0@postgresql.org>
 <CAKFQuwY=-O7-Bnq8PuAtH1TR=y=nmj3U+YqKEeemCM91=or3OA@mail.gmail.com>
 <60f459d7-9cfc-4417-8944-a44581edbe4d@gmail.com>
 <ac7d412b-dd3e-4c6f-afb6-80d2f11bf833@vondra.me>
 <CAOn6LZqgcnXFAdkoxRUTnH5B0g_JN0EmCNERvRREpT0_ZCvBog@mail.gmail.com>
 <9ce91971-2771-4b3c-aad4-b3d5b952d5d1@vondra.me>
 <CAOn6LZoQi+LyPLaf17qP11a5pyy5v+SNu8CAvf+4aTUwhD0O=w@mail.gmail.com>
 <5232B290-5C90-4819-A0F6-A07DE14A20C4@yesql.se>
 <CAOn6LZr-ZZjMEbSDSoGZO_hPT7zhLJ-z9c_wPdizPAqHJtnaRQ@mail.gmail.com>
To: Maciej Jaros <eccenux@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/5B1E7108-CB1F-4CE9-AC09-2C9299C097C2%40yesql.se>
Precedence: bulk

> On 8 Nov 2024, at 11:29, Maciej Jaros <eccenux@gmail.com> wrote:
>=20
> I can now confirm that JIT is adding significant amount of memory on =
top of what PG SQL is using. Memory reserved by PG still grows every =
day, but doesn't grow as much as with JIT. So there is still something =
wrong with Postgres.

Using memory isn't necessarily something wrong, it would be a lot worse =
if it
needed the memory and used swap instead.  Are you able to try with JIT =
inlining
turned off as I asked about upthread.

--
Daniel Gustafsson