Re: Optimization of some jsonb functions - Mailing list pgsql-hackers

From David Steele
Subject Re: Optimization of some jsonb functions
Date
Msg-id 700fcc48-7e30-aa80-83de-99d6015dfc81@pgmasters.net
Whole thread Raw
In response to Re: Optimization of some jsonb functions  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: Optimization of some jsonb functions
List pgsql-hackers
Hi Andrew,

On 3/6/19 9:50 PM, Andrew Dunstan wrote:
> 
> On 3/5/19 5:24 AM, David Steele wrote:
>> 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.
>>
>>
> 
> I think that's overly cautious. The first one I looked at, to optimize
> JsonbExtractScalar, is very small, self-contained, and I think low risk.
> I haven't looked at the others in detail, but I think at least some part
> of this is reasonably committable.
> 
> 
> I'll try to look at the others fairly shortly.

If you decide all or part of this can be committed then feel free to 
update the target version.

Regards,
-- 
-David
david@pgmasters.net


pgsql-hackers by date:

Previous
From: Chris Travers
Date:
Subject: Re: Ltree syntax improvement
Next
From: Alexey Kondratov
Date:
Subject: Re: [Patch] pg_rewind: options to use restore_command fromrecovery.conf or command line