Обсуждение: More efficient access of JSON array elements?
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.
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