pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Daniel Gustafsson <daniel@yesql.se>
To: Maciej Jaros <eccenux@gmail.com>
Cc: Tomas Vondra <tomas@vondra.me>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18675: Postgres is not realasing memory causing OOM
Date: Tue, 12 Nov 2024 15:56:07 +0100
Message-ID: <5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se> (raw)
In-Reply-To: <CAOn6LZr-ZZjMEbSDSoGZO_hPT7zhLJ-z9c_wPdizPAqHJtnaRQ@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>
	<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>

> On 8 Nov 2024, at 11:29, Maciej Jaros <eccenux@gmail.com> wrote:
> 
> 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






view thread (15+ messages)

Message-ID: <5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se>
Permalink:  ../5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se/
Also on:    postgresql.org/message-id/5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: daniel@yesql.se, eccenux@gmail.com, tomas@vondra.me, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #18675: Postgres is not realasing memory causing OOM
  In-Reply-To: <5B1E7108-CB1F-4CE9-AC09-2C9299C097C2@yesql.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox