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. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services