Re: Making jsonb_agg() faster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Lakhin <exclusion(at)gmail(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Making jsonb_agg() faster
Date: 2025-12-13 15:54:33
Message-ID: 1178694.1765641273@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexander Lakhin <exclusion(at)gmail(dot)com> writes:
> I and SQLsmith have discovered that the following query:
> select jsonb_object_agg_unique_strict(i, null) over (order by i) from
>           (select i from generate_series(1, 20) g(i));

> triggers SIGSEGV:

Thanks for the report! It seems to be specific to use as a window
function; I see no problem without the OVER clause. Will look closer
later.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-12-13 15:57:36 Re: Fix out-of-date comment on makeRangeConstructors
Previous Message Peter Eisentraut 2025-12-13 15:52:43 Re: Clarify temporal FK comments