Re: to_jsonb performance on array aggregated correlated subqueries

Justin Pryzby <pryzby@telsasoft.com>

From: Justin Pryzby <pryzby@telsasoft.com>
To: Nico Heller <nico.heller@posteo.de>
Cc: pgsql-performance@lists.postgresql.org
Date: 2022-08-12T19:10:53Z
Lists: pgsql-performance
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