Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1nc5aw-0008Kc-Bm
	for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Apr 2022 13:21:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1nc5au-0007zN-Vp
	for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Apr 2022 13:21:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andrew@dunslane.net>)
	id 1nc5au-0007zD-MT
	for pgsql-hackers@lists.postgresql.org; Wed, 06 Apr 2022 13:21:08 +0000
Received: from relay1-d.mail.gandi.net ([217.70.183.193])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andrew@dunslane.net>)
	id 1nc5an-000638-SW
	for pgsql-hackers@postgresql.org; Wed, 06 Apr 2022 13:21:07 +0000
Received: (Authenticated sender: adsend@dunslane.net)
	by mail.gandi.net (Postfix) with ESMTPSA id 0C991240006;
	Wed,  6 Apr 2022 13:20:56 +0000 (UTC)
Message-ID: <815e5590-bc8b-7d9c-3bca-e0fe15023f26@dunslane.net>
Date: Wed, 6 Apr 2022 09:20:54 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
Subject: Re: SQL/JSON: JSON_TABLE
Content-Language: en-US
To: Andres Freund <andres@anarazel.de>
Cc: Erikjan Rijkers <er@xs4all.nl>,
 Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>,
 Julien Rouhaud <rjuju123@gmail.com>, Nikita Glukhov
 <n.gluhov@postgrespro.ru>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>,
 Pavel Stehule <pavel.stehule@gmail.com>,
 Dmitry Dolgov <9erthalion6@gmail.com>, Oleg Bartunov <obartunov@gmail.com>
References: <20220118063213.a2oyiy3qboyv32aj@jrouhaud>
 <194755c5-3450-b746-4462-233f241203ce@dunslane.net>
 <9e28ea54-e487-039e-28ee-0efd04a60ef9@dunslane.net>
 <CAPF61jDjaUx58qzjZT_C4X5_UP7sADtH+mfXuWimtmrjR+0HAA@mail.gmail.com>
 <5b237456-20f0-632a-c8d1-ce8ad9f47999@dunslane.net>
 <d5f0fc28-b3fd-a512-8e06-836fe9fb2117@xs4all.nl>
 <7675f582-3550-a0c6-7e6d-2febfe47bc0a@dunslane.net>
 <bbf93f05-3cc8-1efa-c08e-ec441812db52@dunslane.net>
 <c9a128c6-5ea6-0494-f281-39026fbe09eb@dunslane.net>
 <cb6ce329-2899-9a2c-80d9-62284f2e570f@dunslane.net>
 <20220406022118.3ocqvhxr6kciw5am@alap3.anarazel.de>
From: Andrew Dunstan <andrew@dunslane.net>
In-Reply-To: <20220406022118.3ocqvhxr6kciw5am@alap3.anarazel.de>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/815e5590-bc8b-7d9c-3bca-e0fe15023f26%40dunslane.net>
Precedence: bulk


On 4/5/22 22:21, Andres Freund wrote:
> Hi,
>
> On 2022-03-27 16:53:57 -0400, Andrew Dunstan wrote:
>> I'm therefore going to commit this series
> The new jsonb_sqljson test is, on my machine, the slowest test in the main
> regression tests:
>
> 4639 ms jsonb_sqljson
> 2401 ms btree_index
> 2166 ms stats_ext
> 2027 ms alter_table
> 1616 ms triggers
> 1498 ms brin
> 1489 ms join_hash
> 1367 ms foreign_key
> 1345 ms tuplesort
> 1202 ms plpgsql
>
> Any chance the slowness isn't required slowness?



I'll take a look.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com