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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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.


In response to


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