Re: Optimization of some jsonb functions

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Joe Nelson <joe(at)begriffs(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, 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-09-18 22:18:13
Message-ID: 20190918221813.GA18650@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2019-Jul-26, Joe Nelson wrote:

> Thomas Munro wrote:
> > This doesn't apply -- to attract reviewers, could we please have a rebase?
> To help the review go forward, I have rebased the patch on 27cd521e6e.
> It passes `make check` for me, but that's as far as I've verified the
> correctness.
> I squashed the changes into a single patch, sorry if that makes it
> harder to review than the original set of five patch files...

Well, I think that was useless, so I rebased again -- attached.
(Thanks, git-imerge).

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v3-0001-Optimize-JsonbExtractScalar.patch text/x-diff 1.6 KB
v3-0002-Optimize-jsonb-operator-using-extracted-JsonbValu.patch text/x-diff 6.2 KB
v3-0003-Optimize-JsonbContainer-type-recognition-in-get_j.patch text/x-diff 1.3 KB
v3-0004-Extract-findJsonbKeyInObject.patch text/x-diff 10.8 KB
v3-0005-Optimize-resulting-JsonbValue-allocation-in-findJ.patch text/x-diff 8.6 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Chapman Flack 2019-09-18 22:47:15 Re: Define jsonpath functions as stable
Previous Message Tomas Vondra 2019-09-18 21:58:08 Re: subscriptionCheck failures on nightjar