Re: to_jsonb performance on array aggregated correlated subqueries

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Nico Heller <nico(dot)heller(at)posteo(dot)de>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: to_jsonb performance on array aggregated correlated subqueries
Date: 2022-08-12 19:10:53
Message-ID: 20220812191053.GH26198@telsasoft.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2022-08-12 19:15:35 Re: to_jsonb performance on array aggregated correlated subqueries
Previous Message Nico Heller 2022-08-12 19:07:20 Re: to_jsonb performance on array aggregated correlated subqueries