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@xxxxxxxxxx> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
