pgsql: Optimize get_jsonb_path_all avoiding an iterator - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Optimize get_jsonb_path_all avoiding an iterator
Date
Msg-id E1iBRWi-0002ov-Ha@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Optimize get_jsonb_path_all avoiding an iterator

Instead of creating an iterator object at each step down the JSONB
object/array, we can just just examine its object/array flags, which is
faster.  Also, use the recently introduced JsonbValueAsText instead of
open-coding the same thing, for code simplicity.

Author: Nikita Glukhov
Discussion: https://postgr.es/m/7c417f90-f95f-247e-ba63-d95e39c0ad14@postgrespro.ru

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/dbb9aeda9959d8a8f463e841b69dfa04afc67a3a

Modified Files
--------------
src/backend/utils/adt/jsonfuncs.c | 33 ++++++++++-----------------------
1 file changed, 10 insertions(+), 23 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix some minor spec-compliance issues in jsonpath lexer.
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Split out code into new getKeyJsonValueFromContainer()