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 1lUB2r-0008MV-Gd for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Apr 2021 16:28:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUB2q-0005wp-Eu for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Apr 2021 16:28:44 +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 1lUB2q-0005u5-33 for pgsql-bugs@lists.postgresql.org; Wed, 07 Apr 2021 16:28:44 +0000 Received: from mail-qt1-x82a.google.com ([2607:f8b0:4864:20::82a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lUB2o-0003XK-1B for pgsql-bugs@lists.postgresql.org; Wed, 07 Apr 2021 16:28:43 +0000 Received: by mail-qt1-x82a.google.com with SMTP id f12so14184772qtq.4 for ; Wed, 07 Apr 2021 09:28:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=systemguards-com-ec.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=0lwDRotdNZVAM0yVWc06rIA5XHsdc52O4NaS3LwWCLg=; b=TtvsYZu1IKXSIw+AtzWty3z/mEnQEKBWFsIbfWEfZw1PmJ6A81OqLdn2lRV7WUY9Rg ryHw+JH/SClVsnL2poSkqnMcOdfLRo9JuyI/1Zjkmuz2u6KIlZA9McO4kd/nDieV5gXi bBhmHw2l04iF51pIr5tOLlin05p5DTPLsFLh8xuzVxqPfywstTobiExLyKnKQ0v01wt2 LfBFJ4NNyvKVBLGFXrHxNri5B2qx/4rfVT+fF7+0eHqKwWD58xJ2vtBEuEB+/3NHm13B 3rQLn6G8vza2QNeBj3tyBgDRWq9hicMEOlW+phfV4j0CWzklqGANdTB2Ey1+aQJKgaRA t3ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=0lwDRotdNZVAM0yVWc06rIA5XHsdc52O4NaS3LwWCLg=; b=CBpE81DOIXCukhibnd5MelEPHHE/m+0vrADOcmQPxjOBmjAPxqFiDwdmaHMeTp5MY5 O7uq8rXjpedpdiBfB+Aji3I+KpgP2QeCEoUDK3/GaeC5A61l1FRHTBCUOcORvnw6apkZ gggjPHzXw34+kBTQjcvs3DEnRxk6QASBguwbOrDrbZ3D7rLkxS8KtJmwaraA1gH8d3r9 SNXcOjD3ecL8nu437zVmlYg2uT5L2Nr0hXhxy3USBzVFVDGJX1tpBujWhMSu4OrK9SHQ EOBpNOslNMpy+iXq+98Zr3y7vlB6oezSVIOadez1n7jxTwKt9a/M7cWVhUQWI21EjoVd 3Uiw== X-Gm-Message-State: AOAM532+Xpa+mKDlmoMzEXABgwe/lBwGvxK7Sc73Ynn7q842QrkCbw9H 4kE4O3aLcpJ6v/tpSO7qp6Z38w== X-Google-Smtp-Source: ABdhPJwCCixDPjzk5AO++h2hV3Whobq5YZ5HwqN25WrAd5Mphw1h9d6CMCY+2bn/1wZqJHSwSM0STA== X-Received: by 2002:aed:306c:: with SMTP id 99mr3392614qte.352.1617812920673; Wed, 07 Apr 2021 09:28:40 -0700 (PDT) Received: from ahch-to ([201.183.3.124]) by smtp.gmail.com with ESMTPSA id z7sm18363191qkf.136.2021.04.07.09.28.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 07 Apr 2021 09:28:40 -0700 (PDT) Date: Wed, 7 Apr 2021 11:28:35 -0500 From: Jaime Casanova To: Andres Freund Cc: Kurt Roeckx , Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16707: Memory leak Message-ID: <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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201111013808.4cev55uxq32bd6dd@alap3.anarazel.de> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. should we document it somewhere? -- Jaime Casanova Director de Servicios Profesionales SystemGuards - Consultores de PostgreSQL