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 1rOHyu-002xsN-D5 for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 13:53:56 +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 1rOHyt-0025L1-7e for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 13:53:55 +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 1rOHys-0025Kt-Ts for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 13:53:54 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rOHyl-001C3o-FM for pgsql-hackers@postgresql.org; Fri, 12 Jan 2024 13:53:53 +0000 Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-5588ac5d988so2397128a12.3 for ; Fri, 12 Jan 2024 05:53:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705067626; x=1705672426; darn=postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:from:to:cc:subject:date:message-id:reply-to; bh=H5T1G0lxns0OUkDXLWSLy3aTKofm743TX+Gva/41VgI=; b=J+Jhz7PuJ4ezs0XJbkt+3PM6bhITFqfQkIIrmEVRiiZuXjrfNAiyG3wDIM0cmSTgE3 j1M//Q94OaFUjTMz27TDZioNxLpGsUErehD5uwfcdF1bjospGcpXanuhPrLoE+ihQOmm q1TfUhZWchjQS1AJHKxTyYHAuPkzc2jBAXZZLPjxycCpg99mTynMXOD3HAgHy4u/S273 9HKGWaEplUVKobSFwlb4H1oLbgGtZQ5WOLseIbjcQ1lCPCQeV0jJcEpycWnay3SrMLYx Suj84SK2Jzt3Et9WQc/FqGWXpYAS9KtF9FbH67ptnB93dn89XNaAYX7ivJsOU59jvr9+ +8jA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705067626; x=1705672426; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=H5T1G0lxns0OUkDXLWSLy3aTKofm743TX+Gva/41VgI=; b=qasDUoWsuCwGJQbiE3MENYKZqDI/bQLNxSk6KnVyltG8Qflwt9zlsQZdU9vPFLxpGd KXtIEKSAKVoS93mzptxUfgoghpA4xL6RTergldEZUFFC5sSXS6onLPHiS6+Tmct7091S N0ZWFU6UvptQGxoUfaePWM7vMzwRk1pafQFfH7FMey/fHsiNuYVi8RqOckbPrl31HrIX EPdmBo7xaSkv9i8yu2/QpR5UgFPr7FeuSGO1I40Y/a+yop5aowtwgGIFyjRQuItB/b1q 0rEvBIViPty64v8QsvuDL4klv5RtRbbFQ9+IoP1YPKUEIefoyl07oeVOJZgQEanr4TMp 5YlQ== X-Gm-Message-State: AOJu0Yzey8Sv2iAbfPXpFM1djmegqz6ycVqm8zVZcQYGsFrly3RYjLU3 bzFRFXpWamwJLNQgclf5JD8= X-Google-Smtp-Source: AGHT+IGB3NISzCmchq3G6wKtLlzxKSrOSWyrUZpcjHFAA70c1YocmWBKHQJv7KHu0bf2OR1wvsl4UQ== X-Received: by 2002:aa7:c59a:0:b0:558:cd71:eed9 with SMTP id g26-20020aa7c59a000000b00558cd71eed9mr374925edq.90.1705067626154; Fri, 12 Jan 2024 05:53:46 -0800 (PST) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:10cd:8701:ed11:b7eb:8de7:fbd6]) by smtp.gmail.com with ESMTPSA id fd4-20020a056402388400b0055864f99f78sm1827167edb.20.2024.01.12.05.53.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 12 Jan 2024 05:53:45 -0800 (PST) Message-ID: <65a14469.050a0220.fead0.7c6d@mx.google.com> X-Google-Original-Message-ID: <20240112135344.GE3613@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1rOHyj-0004QT-74; Fri, 12 Jan 2024 14:53:45 +0100 Date: Fri, 12 Jan 2024 14:53:45 +0100 From: Michael Banck To: Pavel Stehule Cc: PostgreSQL Hackers Subject: Re: plpgsql memory leaks References: <65a11a66.170a0220.fd97.5da6@mx.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: 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 Hi, On Fri, Jan 12, 2024 at 01:35:24PM +0100, Pavel Stehule wrote: > pá 12. 1. 2024 v 11:54 odesílatel Michael Banck 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 memleaks > > that can be worked-around by setting jit_inline_above_cost=0. 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. Michael