Horton

Re: Optimization of some jsonb functions

David Steele <david@pgmasters.net>

View thread View on postgr.es
From: David Steele <david@pgmasters.net>
To: Nikita Glukhov <n.gluhov@postgrespro.ru>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2019-03-05T10:24:23Z
Lists: pgsql-hackers 
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.

Regards,
-- 
-David
david@pgmasters.net

Commits

  1. Split out code into new getKeyJsonValueFromContainer()

  2. Optimize get_jsonb_path_all avoiding an iterator

  3. Refactor code into new JsonbValueAsText, and use it more