Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h17Fb-00069X-DH for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Mar 2019 10:24:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h17FY-0001rv-B2 for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Mar 2019 10:24:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h17FX-0001rm-WF for pgsql-hackers@lists.postgresql.org; Tue, 05 Mar 2019 10:24:40 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h17FQ-0007S9-Jm for pgsql-hackers@postgresql.org; Tue, 05 Mar 2019 10:24:38 +0000 Received: from Davids-MacBook.local (unknown [208.54.80.128]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id A41A05466C; Tue, 5 Mar 2019 10:24:30 +0000 (UTC) Subject: Re: Optimization of some jsonb functions To: Nikita Glukhov , PostgreSQL mailing lists References: <7c417f90-f95f-247e-ba63-d95e39c0ad14@postgrespro.ru> From: David Steele Message-ID: <5e8027a6-e175-55f8-96c8-0e24dd30e97f@pgmasters.net> Date: Tue, 5 Mar 2019 12:24:23 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:60.0) Gecko/20100101 Thunderbird/60.5.0 MIME-Version: 1.0 In-Reply-To: <7c417f90-f95f-247e-ba63-d95e39c0ad14@postgrespro.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2/22/19 2:05 AM, Nikita Glukhov wrote: > Attached set of patches with some jsonb optimizations that were made during > comparison of performance of ordinal jsonb operators and jsonpath operators. This patch was submitted just before the last commitfest for PG12 and seems to have potential for breakage. I have updated the target to PG13. Regards, -- -David david@pgmasters.net