Re: to_jsonb performance on array aggregated correlated subqueries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: to_jsonb performance on array aggregated correlated subqueries
From: Justin Pryzby <pryzby@xxxxxxxxxxxxx>
Date: Fri, 12 Aug 2022 13:56:06 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <1eac0b83-217d-94d2-cde2-db74ae3fbe86@posteo.de>
References: <1eac0b83-217d-94d2-cde2-db74ae3fbe86@posteo.de>
User-agent: Mutt/1.9.4 (2018-02-28)

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

Follow-Ups:
- Re: to_jsonb performance on array aggregated correlated subqueries
  - From: Nico Heller

References:
- to_jsonb performance on array aggregated correlated subqueries
  - From: Nico Heller

Prev by Date: to_jsonb performance on array aggregated correlated subqueries
Next by Date: Re: to_jsonb performance on array aggregated correlated subqueries
Previous by thread: to_jsonb performance on array aggregated correlated subqueries
Next by thread: Re: to_jsonb performance on array aggregated correlated subqueries
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux