Re: Jsonb first level keys statistic - Mailing list pgsql-general

From Michael Lewis
Subject Re: Jsonb first level keys statistic
Date
Msg-id CAHOFxGp593cbHyopE8_Bv_T1vL8mNXgOR=WhWgBy_nxHa-B82A@mail.gmail.com
Whole thread Raw
In response to Jsonb first level keys statistic  (Игорь Выскорко <vyskorko.igor@yandex.ru>)
List pgsql-general
Other than creating a functional index on the keys that you most want to access and include that function call in your query, I don't know that you can. Functional indexes get statistics while partial indexes do not. If a GIN index using path operator collected stats on the frequency of the keys, then you would be all set I think. Perhaps that is a feature that could be implemented.

Others will chime in I expect, but I tend to avoid using jsonb for any values that I need to use to significant filter a result set (ON and WHERE clauses).

pgsql-general by date:

Previous
From: Игорь Выскорко
Date:
Subject: Jsonb first level keys statistic
Next
From: Nicola Contu
Date:
Subject: Re: ERROR: too many dynamic shared memory segments