Обсуждение: More efficient access of JSON array elements?

Поиск
Список
Период
Сортировка

More efficient access of JSON array elements?

От
Wells Oliver
Дата:
Hi: I'm wondering if there's an application of GIN (or otherwise) indexing with jsonb columns to help speed up some queries where I'm not using WHERE clauses, but unpacking rather large json objects to rows via jsonb_array_elements: it seems indexing largely helps when filtering, but this is more unpacking/flattening with really quite sizable objects.

PG 12.3.

--

Re: More efficient access of JSON array elements?

От
Bruce Momjian
Дата:
On Sat, Jul 18, 2020 at 06:22:20PM -0700, Wells Oliver wrote:
> Hi: I'm wondering if there's an application of GIN (or otherwise) indexing with
> jsonb columns to help speed up some queries where I'm not using WHERE clauses,
> but unpacking rather large json objects to rows via jsonb_array_elements: it
> seems indexing largely helps when filtering, but this is more unpacking/
> flattening with really quite sizable objects.

You can use JSON (not JSONB) to get faster loading/unloading, but much
slower filtering.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee