More efficient access of JSON array elements? - Mailing list pgsql-admin

From Wells Oliver
Subject More efficient access of JSON array elements?
Date
Msg-id CAOC+FBXgTnmVE24uvG4FyFiXCnRxp2p0FTkx9fpoDZc4N6D27w@mail.gmail.com
Whole thread Raw
Responses Re: More efficient access of JSON array elements?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
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.

--

pgsql-admin by date:

Previous
From: Mayur Mundada
Date:
Subject: Re: Encryption password for Backup
Next
From: Scott Ribe
Date:
Subject: Re: Encryption password for Backup