From: Tom Lane <tgl@sss.pgh.pa.us>
To: Maciej Jaros <eccenux@gmail.com>
cc: Tomas Vondra <tomas@vondra.me>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18675: Postgres is not realasing memory causing OOM
In-reply-to: 
 <CAOn6LZqgcnXFAdkoxRUTnH5B0g_JN0EmCNERvRREpT0_ZCvBog@mail.gmail.com>
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>
Comments: In-reply-to Maciej Jaros <eccenux@gmail.com>
	message dated "Tue, 29 Oct 2024 13:26:09 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <241664.1730218432.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 29 Oct 2024 12:13:52 -0400
Message-ID: <241665.1730218432@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/241665.1730218432%40sss.pgh.pa.us>
Precedence: bulk

Maciej Jaros <eccenux@gmail.com> writes:
> So, that comment led me to suggest adding some kind of process. I called it
> a garbage collector, but maybe David is right; maybe that’s not accurate.
> Anyway, that process, in my view, could try to actually release memory to
> the system to prevent the OOM killer from doing its bidding. Is that
> possible?

We do not even know what is causing your problem, let alone know a
way that one process could command another one to stop doing it.
So no, this suggestion is not helpful.

			regards, tom lane