Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUB6P-00007y-PG for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Apr 2021 16:32:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUB6O-0002Jn-K1 for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Apr 2021 16:32:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUB6N-0002Jg-3E for pgsql-bugs@lists.postgresql.org; Wed, 07 Apr 2021 16:32:24 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUB6K-0003Ya-9Y for pgsql-bugs@lists.postgresql.org; Wed, 07 Apr 2021 16:32:22 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 8554B5C00AC; Wed, 7 Apr 2021 12:32:17 -0400 (EDT) Received: from imap35 ([10.202.2.85]) by compute1.internal (MEProxy); Wed, 07 Apr 2021 12:32:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= mime-version:message-id:in-reply-to:references:date:from:to:cc :subject:content-type; s=fm1; bh=ieEWdABijLhBtw5Ts8AoUK4U2uuL/Vq LzHN4Db+/oD0=; b=Na9TXGL3EgzCuil2cTnbPoLMKHplqIgf2ICNXhDnp+r0CGj GhA81wlnMYMNh/aYM2yjQNSugDYTu4XHFNT9ARBJ6SxI049GnoctKFpX5TLLmifR fL2k9GqcprsytgwFKeJ0WKXUmCJl+ngwC7MZF5GHZlaXI8VDhtk5W45NOR1kM36d uzxhkvyXXkEgScvVCvgOVT9BhBa7r8HwvwauVD6h1H8O7Pj+Yx9YXILIysws6A2u 77HdgT8An6I5hlQVGEYXxgnAgUfEG0/lixNmFmf8wE95oc5nWkbZVqr/f55cAIoq wQd3kzYKJoWJUVyh+e3Ip6GniVda7Sj8UM29QBw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=ieEWdA BijLhBtw5Ts8AoUK4U2uuL/VqLzHN4Db+/oD0=; b=c0/2hQFA4teAtg4Jzqjsi8 OecA/FG2Nx6PQyANeR+yXRNRJJI+G0GXtqnWLlVsxUox35RFSqWFrFjJeHliheaf jdrXURGjbBJnOK0do2TUI0PYVphvBPn5WTuUqDBhR4xXpF5oIGI7eI4Aq1agIjZf SvZScvSt8VRULJJqVqFV+J0AubZmGt+M7NMMUOmZS/xnnKbW4UtdAzWkBqwTgYMu 8jrHLsqOfrR8S34cB1YQXAbbauFkCLLr2jpmeSNyPKk1D2CWu2Mi8nfXvo8KwQlH +8Yg4LNAwfyobiFaGPFnogLbp3xE5k27myTMQfwLVacKEk+w4TfEm3AlkXKrPV9g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudejjedguddtvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefofgggkfgjfhffhffvufgtsehttdertderredtnecuhfhrohhmpedftehn ughrvghsucfhrhgvuhhnugdfuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenuc ggtffrrghtthgvrhhnpeetgedvvdffgefhjeetveetveefgeffudduffegtdeujedvjeel gfevgedukeefvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfh hrohhmpegrnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id 78FF715A005F; Wed, 7 Apr 2021 12:32:16 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-273-g8500d2492d-fm-20210323.002-g8500d249 Mime-Version: 1.0 Message-Id: <7acc8678-df5f-4923-9cf6-e843131ae89d@www.fastmail.com> In-Reply-To: <20210407162835.GB2857@ahch-to> References: <16707-f5df308978a55bf8@postgresql.org> <1999972.1604957673@sss.pgh.pa.us> <20201109220329.GC391173@roeckx.be> <2002012.1604960437@sss.pgh.pa.us> <20201110043127.sfkyvvjqy7x3er5k@alap3.anarazel.de> <20201110081120.GF391173@roeckx.be> <20201110193517.t5hbqkya67gb23rq@alap3.anarazel.de> <20201110195039.GG391173@roeckx.be> <20201110224516.GA568918@roeckx.be> <20201111013808.4cev55uxq32bd6dd@alap3.anarazel.de> <20210407162835.GB2857@ahch-to> Date: Wed, 07 Apr 2021 09:31:54 -0700 From: "Andres Freund" To: "Jaime Casanova" Cc: "Kurt Roeckx" , "Tom Lane" , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16707: Memory leak Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Wed, Apr 7, 2021, at 09:28, Jaime Casanova wrote: > On Tue, Nov 10, 2020 at 05:38:08PM -0800, Andres Freund wrote: > > Hi, > > > > On 2020-11-10 23:45:16 +0100, Kurt Roeckx wrote: > > > On Tue, Nov 10, 2020 at 08:50:39PM +0100, Kurt Roeckx wrote: > > > > > There's one known (slow) memory leak in the JIT code / LLVM. Could you > > > > > check if the issue vanishes if you disable JIT (jit = 0)? > > > > > > > > I've just restarted it with jit = 0. > > > > > > It's been about 3 hours since the restart, and it looks much > > > better, it seems to be solved. > > > > Hm, darn. Any chance you could check if the leak is present if you turn > > on jit again, but disable inlining with jit_inline_above_cost=-1? If > > that still fixes the leak I think I know the issue / have a reproducer > > already... > > > > I was bit by this too while testing something. I thought it could have been > a problem caused by the support of llvm 12? but given that this report > is for pg12, it seems this is older than that. I hope to fix it soon - I have two different mostly working fixes. I'll get back to it once the dust around the freeze settles. Andres