Re: Performance of JSON_TABLE vs jsonb_to_recordset - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Performance of JSON_TABLE vs jsonb_to_recordset
Date
Msg-id 2450295.1713625111@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance of JSON_TABLE vs jsonb_to_recordset  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> Alexander Lakhin <exclusion@gmail.com> writes:
>> explain (verbose, analyze)
>> select
>>   (select max((select i.unique2 from tenk1 i where i.unique1 = o.unique1)))
>> from tenk1 o;
>> -- original tenk1
>>  Execution Time: 4769.481 ms

> Hm, I get about 13 ms for that example.  Do you have some really
> expensive debugging infrastructure enabled, perhaps?

Oh, never mind, now I see you are testing a version of the table
with no indexes, rather than the way it's set up in the regression
database.  Apologies for the noise.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance of JSON_TABLE vs jsonb_to_recordset
Next
From: Peter Eisentraut
Date:
Subject: Re: AIX support