Date: Wed, 22 Jul 2020 14:42:25 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: More efficient access of JSON array elements?
Message-ID: <20200722184225.GD3899@momjian.us>
References: 
 <CAOC+FBXgTnmVE24uvG4FyFiXCnRxp2p0FTkx9fpoDZc4N6D27w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAOC+FBXgTnmVE24uvG4FyFiXCnRxp2p0FTkx9fpoDZc4N6D27w@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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