Re: Optimization of some jsonb functions

From: David Steele <david(at)pgmasters(dot)net>
To: Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimization of some jsonb functions
Date: 2019-03-07 12:23:53
Message-ID: 700fcc48-7e30-aa80-83de-99d6015dfc81@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Kondratov 2019-03-07 12:27:25 Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line
Previous Message Chris Travers 2019-03-07 12:09:49 Re: Ltree syntax improvement