Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlbPz-003YO4-Uu for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Sep 2023 20:45:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qlbPy-005lys-4Z for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Sep 2023 20:45:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlbPx-005lyf-RY for pgsql-bugs@lists.postgresql.org; Wed, 27 Sep 2023 20:45:58 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qlbPv-007xah-KD for pgsql-bugs@lists.postgresql.org; Wed, 27 Sep 2023 20:45:57 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 5188A32009CE; Wed, 27 Sep 2023 16:45:53 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 27 Sep 2023 16:45:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1695847552; x=1695933952; bh=U9 lbu0IGG90WPlfyMsQh1gw9Lg/gz43/lDIwJggwD98=; b=dOkHhK12ddF90JSIe0 nGgWvrPpbbXEF9Ka2AdFmALVI5a2j8+zEcibuGy9WwSI7/mbkgeSsLBIv26qTJYk 0sUnhu1K/NFxGoJzv8tCwgagkVEqvjzFkAgKPBET56fPot3xLmCbUaGx60UQBrfe TzK37kOGxSa3xg3Pk8rJwfj8ora4cKW0ko3AgZB/LkUVVxuzma/hN/lI/OBhXP2x FVTyxT+d5n9u1Xnb10KR8NozzKe1nBz3t9niczmzFxiFnpaVzE7pdFsEvnIYE04R K4uREb5W31c0t3OT5o+yX2+PAWfXk/qhlB9n8V2rgRyfHA0kwrWIx9N7/JbnPgxz aS5g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1695847552; x=1695933952; bh=U9lbu0IGG90WP lfyMsQh1gw9Lg/gz43/lDIwJggwD98=; b=X1KU6g5pCkXgwwGOdWe+035YjkzUW Q7e7GprPOnsbF7Yk+gAieQs8zgUTWqdat2dn1KRUXbLaZdqHVWoXBTrK6nYOMrzj /zfPhb8k5t6OagtyH9IDnERR9XJGRVUBfqDndHVp/7Am0GgZ3XMeVSPfJvHqPSSr Fj42Vvu63bn7z/oS2Yr3MfHPQwl88v4kABen3UQRCsIaV+haCA7xemSrbn3yZKTd XBNoLu0JOuItSkEIpJ0gSv720yPSRb0NqnNOAHol55pgGvafXT3JKitfRqqZWz9y JfAbmuhah0dZLXs/vJqOzDecHfm4wbuRDm0YXA6IBb/wQ+yNJRawDbySQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvjedrtdeggdeltdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedvffefvefhteevffegieetfefhtddvffejvefhueetgeeludehteevudei tedtudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 27 Sep 2023 16:45:52 -0400 (EDT) Date: Wed, 27 Sep 2023 13:45:51 -0700 From: Andres Freund To: Daniel Gustafsson Cc: Tom Lane , David Rowley , lauri.laanmets@eesti.ee, pgsql-bugs Subject: Re: Memory leak on subquery as scalar operand Message-ID: <20230927204551.ndrn5ol3fhmkoavf@alap3.anarazel.de> References: <1046179.1667263449@sss.pgh.pa.us> <1073512.1667275802@sss.pgh.pa.us> <1084048.1667278336@sss.pgh.pa.us> <20221101055132.pjjsvlkeo4stbjkq@awork3.anarazel.de> <71272FCF-3DD2-440A-B849-4ACB8B16F213@yesql.se> <452E97A1-93EE-473C-A9D3-E878EF3543CF@yesql.se> <0D8E32CD-615C-4406-A4C4-C1A101148E28@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0D8E32CD-615C-4406-A4C4-C1A101148E28@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-09-27 14:07:16 +0200, Daniel Gustafsson wrote: > > On 13 Sep 2023, at 15:24, Daniel Gustafsson wrote: > > > I think it would be good to get this in early in the v17 cycle such that we > > have time to revisit the herustic if need be. > > With an offlist +1 from Andres, and another couple of rounds of read-throughs > and jit_above_cost=0 check-worlds I went ahead and applied this to master. The > buildfarm has green builds for LLVM enabled builds on Linux, FreeBSD and macOS. Thanks a lot or working on this!