Date: Wed, 22 Feb 2023 13:43:00 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, David Rowley <dgrowleyml@gmail.com>,
	lauri.laanmets@eesti.ee, pgsql-bugs@lists.postgresql.org
Subject: Re: Memory leak on subquery as scalar operand
Message-ID: <20230222194300.GF1653@telsasoft.com>
References: 
 <CAPH-tTxLf44s3CvUUtQpkDr1D8Hxqc2NGDzGXS1ODsfiJ6WSqA@mail.gmail.com>
 <CAApHDvrSbQkPUacnaonQzw1efFJM6HE5we-i9VVogBfEKGCCiA@mail.gmail.com>
 <1046179.1667263449@sss.pgh.pa.us>
 <CAApHDvpL=3-61Lsfd9P5vuf48sJgKYP1qUULDEoKcAsEJpZA7g@mail.gmail.com>
 <1073512.1667275802@sss.pgh.pa.us>
 <CAApHDvqn55aqReCSAd9tpf06JV0sx=DYON+djSv1BqkJZ+NH_Q@mail.gmail.com>
 <1084048.1667278336@sss.pgh.pa.us>
 <20221101055132.pjjsvlkeo4stbjkq@awork3.anarazel.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20221101055132.pjjsvlkeo4stbjkq@awork3.anarazel.de>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20230222194300.GF1653%40telsasoft.com>
Precedence: bulk

On Mon, Oct 31, 2022 at 10:51:32PM -0700, Andres Freund wrote:
> Hi,
> 
> On 2022-11-01 00:52:16 -0400, Tom Lane wrote:
> > David Rowley <dgrowleyml@gmail.com> writes:
> > > The single subquery version also crashes for me, so perhaps it's just
> > > the amount of memory that's being used and when the OOM killer is
> > > triggering.
> > > It crashes even when I set jit_inline_above_cost and
> > > jit_optimize_above_cost above the query's cost.
> > 
> > Hmm, maybe we're not seeing the same thing?
> 
> I can't reproduce that either.

@David: does the query really crash as you described - with neither jit
inlining nor optimization ?

Is it due to OOM or something else ?
Does it crash with/without Andres' patches ?
What version were you testing ?

-- 
Justin