Re: to_jsonb performance on array aggregated correlated subqueries - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: to_jsonb performance on array aggregated correlated subqueries
Date
Msg-id 20220812191053.GH26198@telsasoft.com
Whole thread Raw
In response to Re: to_jsonb performance on array aggregated correlated subqueries  (Nico Heller <nico.heller@posteo.de>)
List 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



pgsql-performance by date:

Previous
From: Nico Heller
Date:
Subject: Re: to_jsonb performance on array aggregated correlated subqueries
Next
From: Andres Freund
Date:
Subject: Re: to_jsonb performance on array aggregated correlated subqueries