MIME-Version: 1.0
References: <CAFj8pRCWZBS4pXSZd8ibsSivVkzsUn1d8eX0y4jOYmRB+Cw2yg@mail.gmail.com>
 <CAFj8pRATsUvX0j8g9GcXC8N_9w-igEwuBqjAcbrZhL8Jq6uDZw@mail.gmail.com>
 <65a11a66.170a0220.fd97.5da6@mx.google.com> <CAFj8pRB132dKbwZtdEZtxnzXmEW9qrOmnuEpk2rxm9V3fpDFcw@mail.gmail.com>
 <65a14469.050a0220.fead0.7c6d@mx.google.com>
In-Reply-To: <65a14469.050a0220.fead0.7c6d@mx.google.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Fri, 12 Jan 2024 20:09:14 +0100
Message-ID: <CAFj8pRCMjozEaBxuLRXB50CYkPoui4WtbX6XaRKvOYPp+76Zcg@mail.gmail.com>
Subject: Re: plpgsql memory leaks
To: Michael Banck <mbanck@gmx.net>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a3990a060ec468ee"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRCMjozEaBxuLRXB50CYkPoui4WtbX6XaRKvOYPp%2B76Zcg%40mail.gmail.com>
Precedence: bulk

--000000000000a3990a060ec468ee
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

p=C3=A1 12. 1. 2024 v 14:53 odes=C3=ADlatel Michael Banck <mbanck@gmx.net> =
napsal:

> Hi,
>
> On Fri, Jan 12, 2024 at 01:35:24PM +0100, Pavel Stehule wrote:
> > p=C3=A1 12. 1. 2024 v 11:54 odes=C3=ADlatel Michael Banck <mbanck@gmx.n=
et> napsal:
> > > Which version of Postgres is this and on which platform/distribution?
> >
> > It was tested on master branch (pg 17) on Fedora 39
> >
> > > Did you try keep jit on but set jit_inline_above_cost to 0?
> > >
> > > The back-branches have a fix for the above case, i.e. llvmjit memleak=
s
> > > that can be worked-around by setting jit_inline_above_cost=3D0.
>
> I got that wrong, it needs to be -1 to disable it.
>
> But if you are already running the master branch, it is probably a
> separate issue.
>

I tested code

CREATE OR REPLACE FUNCTION public.fx(iter integer)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
declare
  c cursor(m bigint) for select distinct i from generate_series(1, m) g(i);
  t bigint;
  s bigint;
begin
  for i in 1..iter
  loop
    s :=3D 0;
    for r in c(i*10000)
    loop
      s :=3D s + r.i;
    end loop;
    raise notice '%=3D%', i, s;
  end loop;
end;
$function$

default master branch - res 190MB ram
jit_inline_above_cost =3D -1 doesn't helps
disabling JIT doesn't helps too,

so it looks like the wrong hypothesis , and the problem is maybe somewhere
else :-/

Regards

Pavel


>
>
> Michael
>

--000000000000a3990a060ec468ee
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">p=C3=A1 12. 1. 2024 v=C2=A014:53 odes=
=C3=ADlatel Michael Banck &lt;<a href=3D"mailto:mbanck@gmx.net">mbanck@gmx.=
net</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex">Hi,<br>
<br>
On Fri, Jan 12, 2024 at 01:35:24PM +0100, Pavel Stehule wrote:<br>
&gt; p=C3=A1 12. 1. 2024 v 11:54 odes=C3=ADlatel Michael Banck &lt;<a href=
=3D"mailto:mbanck@gmx.net" target=3D"_blank">mbanck@gmx.net</a>&gt; napsal:=
<br>
&gt; &gt; Which version of Postgres is this and on which platform/distribut=
ion?<br>
&gt; <br>
&gt; It was tested on master branch (pg 17) on Fedora 39<br>
&gt; <br>
&gt; &gt; Did you try keep jit on but set jit_inline_above_cost to 0?<br>
&gt; &gt;<br>
&gt; &gt; The back-branches have a fix for the above case, i.e. llvmjit mem=
leaks<br>
&gt; &gt; that can be worked-around by setting jit_inline_above_cost=3D0.<b=
r>
<br>
I got that wrong, it needs to be -1 to disable it.<br>
<br>
But if you are already running the master branch, it is probably a<br>
separate issue.<br></blockquote><div><br></div><div>I tested code</div><div=
><br></div><div>CREATE OR REPLACE FUNCTION public.fx(iter integer)<br>=C2=
=A0RETURNS void<br>=C2=A0LANGUAGE plpgsql<br>AS $function$<br>declare<br>=
=C2=A0 c cursor(m bigint) for select distinct i from generate_series(1, m) =
g(i);<br>=C2=A0 t bigint;<br>=C2=A0 s bigint;<br>begin<br>=C2=A0 for i in 1=
..iter<br>=C2=A0 loop<br>=C2=A0 =C2=A0 s :=3D 0; <br>=C2=A0 =C2=A0 for r in=
 c(i*10000)<br>=C2=A0 =C2=A0 loop<br>=C2=A0 =C2=A0 =C2=A0 s :=3D s + r.i;<b=
r>=C2=A0 =C2=A0 end loop;<br>=C2=A0 =C2=A0 raise notice &#39;%=3D%&#39;, i,=
 s;<br>=C2=A0 end loop;<br>end;<br>$function$<br></div><div><br></div><div>=
default master branch - res 190MB ram</div><div>jit_inline_above_cost =3D -=
1 doesn&#39;t helps</div><div>disabling JIT doesn&#39;t helps too,</div><di=
v><br></div><div>so it looks like the wrong hypothesis , and the problem is=
 maybe somewhere else :-/</div><div><br></div><div>Regards</div><div><br></=
div><div>Pavel<br></div><div><br></div><div>=C2=A0<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">
<br>
<br>
Michael<br>
</blockquote></div></div>

--000000000000a3990a060ec468ee--