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 1oMa3h-0002V8-9o for pgsql-performance@arkaria.postgresql.org; Fri, 12 Aug 2022 19:11:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oMa3f-0005xB-Rk for pgsql-performance@arkaria.postgresql.org; Fri, 12 Aug 2022 19:10:59 +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 1oMa3f-0005x1-HU for pgsql-performance@lists.postgresql.org; Fri, 12 Aug 2022 19:10:59 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oMa3c-0005uW-L2 for pgsql-performance@lists.postgresql.org; Fri, 12 Aug 2022 19:10:58 +0000 Received: by mail-io1-xd2d.google.com with SMTP id l24so1525463ion.13 for ; Fri, 12 Aug 2022 12:10:56 -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=4U1EinWRjO1vgxB7gCaN0e9usqAg2CBWsVFtquMk9II=; b=znBymhgojIpiQ1geQ2Do6O+DUcKeNbMZ31okzSGuc3a6js6SjBYxdsxBTJkJwZVw/5 7oBR8Od+Jg+cQWe8aq9tT14QNvv8/gDsmk1S83LwF0KtYwyiHPjF0Tn01s7nq16vaCt1 yt+qA4GWKOt5E+bjn9faSJF6vdjMQsoy90vyT4rXHQTz8pmA3wjrrm4kWkr1uGiLwGVc TJDyccA1VF/7Zff4SE4nXfYQhFH/6qfgxNlChzPGlh/eBHJxVNQQeWN8JueiE+xuLiJP LVvGtYcfpB1sqefxL03jiwr0mleo2llZhmqQrYdxO4S2iIsiAOLSLW5wxqY7/zKLml1z srnQ== 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=4U1EinWRjO1vgxB7gCaN0e9usqAg2CBWsVFtquMk9II=; b=jNKF2AY0z02Q1YKx2DtVPaqJznc1nKVfX7G2KJ8Y0iEMqTp+05ZsTWIM9h5diX+UEv vVjQiP4LbGdPE97QL6zK88pqDMO1qPrwGt8nmNgU2Dth9SZe0Im59SEpoAHJeXoL9F0g z/w4o4yi0RjWm4pDFxpJXii6fjq1KECheI7ZoyKRpka2bkWlXRTqtxLHd5oj/kjnQxfJ MBcx/okSej8jQaG0mGqoSPPxn6yj2exjlMvZ12XjHrUl2gy93DL2nxnvn1na9nZ9z4iH oByV+SRG/spZuaP+CSnZT8Fvir/UFAShMZn/T1V4kTNLRaM41f9fVU1JR6QaBzkvwHPR YnYA== X-Gm-Message-State: ACgBeo3LWNatcT7QX4NohFNmRZbg0Is1WgkYZq3q0u3J/9mDT1HRMP3X pTpIx4EcWAnCklv2sSdHq3WLW2WtlCRMLg== X-Google-Smtp-Source: AA6agR7WuE97pUm+vu+v3fjrm+Bl4BjaRD77pZjTD7alZEnDYSQqHl0OFIOwLEGNz9p2s7A3HW22Ng== X-Received: by 2002:a05:6638:3e08:b0:343:36ba:8115 with SMTP id co8-20020a0566383e0800b0034336ba8115mr2729504jab.278.1660331454566; Fri, 12 Aug 2022 12:10:54 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id k17-20020a023351000000b00339ee336be1sm205033jak.81.2022.08.12.12.10.54 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Aug 2022 12:10:54 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 60F41800773; Fri, 12 Aug 2022 14:10:53 -0500 (CDT) Date: Fri, 12 Aug 2022 14:10:53 -0500 From: Justin Pryzby To: Nico Heller Cc: pgsql-performance@lists.postgresql.org Subject: Re: to_jsonb performance on array aggregated correlated subqueries Message-ID: <20220812191053.GH26198@telsasoft.com> References: <1eac0b83-217d-94d2-cde2-db74ae3fbe86@posteo.de> <20220812185606.GG26198@telsasoft.com> <9335c458-a1fa-0730-9c1f-0483c39652cb@posteo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9335c458-a1fa-0730-9c1f-0483c39652cb@posteo.de> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Aug 12, 2022 at 07:02:36PM +0000, Nico Heller wrote: > I knew I forgot something: We are currently on 13.6. When was this issue > fixed? There's a WIP/proposed fix, but the fix is not released. I asked about your version because jit was disabled by default in v11. But it's enabled by default in v12. https://wiki.postgresql.org/wiki/PostgreSQL_15_Open_Items#Older_bugs_affecting_stable_branches -- Justin