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 <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1oMZpN-0001su-VS
	for pgsql-performance@arkaria.postgresql.org; Fri, 12 Aug 2022 18:56:14 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1oMZpM-0002o8-S6
	for pgsql-performance@arkaria.postgresql.org; Fri, 12 Aug 2022 18:56:12 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pryzby@telsasoft.com>)
	id 1oMZpM-0002ny-Em
	for pgsql-performance@lists.postgresql.org; Fri, 12 Aug 2022 18:56:12 +0000
Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <pryzby@telsasoft.com>)
	id 1oMZpJ-0001bs-B9
	for pgsql-performance@lists.postgresql.org; Fri, 12 Aug 2022 18:56:11 +0000
Received: by mail-io1-xd29.google.com with SMTP id d187so1508324iof.4
        for <pgsql-performance@lists.postgresql.org>;
 Fri, 12 Aug 2022 11:56:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=telsasoft-com.20210112.gappssmtp.com; s=20210112;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :message-id:subject:cc:to:from:date:from:to:cc;
        bh=E/PLHDjPk/UYLFxRedyRAfhO3BrKJlsAxuL9sZUVA/g=;
        b=F0T8hMhUMud+p8NaMgjCWdmehFY1NmyVCiHUVd/0lRCbXwMVKz5Qn3LbALU6y94oEu
         BZH8lo69Y9wsynGfcJozI5g2DMlKeLJzwnJofWOmaZltwlZqYSQ+3OUFoaHU0Q7yHX1G
         w1hzCGwFQmq4armZMdxzyybJma4tV7nWluNoYBbc57fKl6nJXrYu6XlnUKgTLp2BRs36
         +sSs9H5o5Bwkd/RallWq4MSTFVwkKw7zyrzRIN7MlnQ9nrPiiY033kYGshfPkLX12g8e
         XigUayFyQnHGYZCZw7Tsyf5vjvnfAvzYk9NXxtZtDDxFeWwhHYxfry196gCiReyj5+uv
         QwwQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc;
        bh=E/PLHDjPk/UYLFxRedyRAfhO3BrKJlsAxuL9sZUVA/g=;
        b=J4XOTfblc8Juz4W7+4sBHG6W6L060Ft4rNfaXmr9+jFb3NMtMbkR17wqG6Cbc/80bQ
         P+fJL24zoaAtgv+ENZkmkwhy4dAm3ecOo6FyZjgekR0B52hVwariv5xKDbnsVe0VmOm0
         C54aVgGO3L2f8CnUs5ZAJDeWzFOVLduZ3Y+61LTJT1Euyll7Z4QbQJtKw7RCyiykWaEi
         Y14cRFRbvDDlzMxkSvsP5e2TiITAfBzTe6XpddlsuwGPJRXkGba7O0AWaIY3hLPNGUMO
         M2vC8SSo/iRb59Zh9q1t1V1bOKrrGRwaRjH0WosjelBEX68vJqr36+LBw8XcBWOBzKVD
         7m4g==
X-Gm-Message-State: ACgBeo1U1MBMXjmKxv1d5Xpvoh615iWLip9TyTjHVFNkR/nBMOHWewxg
	greNTRbW+3vL2/j6+EdfTE8UTKzoV6qfww==
X-Google-Smtp-Source: 
 AA6agR6yUMAl8aUQ20sKo7YD1xUW5eI8SKyeQ1neYnQjZOIYobbaXOfM+0ri6aWuOgyrrBLwsd3a9Q==
X-Received: by 2002:a05:6638:150e:b0:343:261:8679 with SMTP id
 b14-20020a056638150e00b0034302618679mr2691358jat.111.1660330568177;
        Fri, 12 Aug 2022 11:56:08 -0700 (PDT)
Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1])
        by smtp.gmail.com with ESMTPSA id
 p9-20020a0566022b0900b0067bf99ea25bsm1229039iov.44.2022.08.12.11.56.07
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128);
        Fri, 12 Aug 2022 11:56:07 -0700 (PDT)
Received: by pryzbyj.telsasoft (Postfix, from userid 1000)
	id D27EE8007F2; Fri, 12 Aug 2022 13:56:06 -0500 (CDT)
Date: Fri, 12 Aug 2022 13:56:06 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Nico Heller <nico.heller@posteo.de>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: to_jsonb performance on array aggregated correlated subqueries
Message-ID: <20220812185606.GG26198@telsasoft.com>
References: <1eac0b83-217d-94d2-cde2-db74ae3fbe86@posteo.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1eac0b83-217d-94d2-cde2-db74ae3fbe86@posteo.de>
User-Agent: Mutt/1.9.4 (2018-02-28)
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/20220812185606.GG26198%40telsasoft.com>
Precedence: bulk

What version of postgres ?

I wonder if you're hitting the known memory leak involving jit.
Try with jit=off or jit_inline_above_cost=-1.

-- 
Justin