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 18:56:06
Message-ID: 20220812185606.GG26198@telsasoft.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nico Heller 2022-08-12 19:02:36 Re: to_jsonb performance on array aggregated correlated subqueries
Previous Message Nico Heller 2022-08-12 18:49:58 to_jsonb performance on array aggregated correlated subqueries