Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Loading table with indexed jsonb field is stalling
From: Will Hartung <willhartung@gmail.com>
In-Reply-To: <0a8876b8-f4de-4bc2-72c8-afe5dfe6fde2@gmail.com>
Date: Mon, 20 May 2019 17:21:09 -0700
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <C3D03C39-1AFD-40BA-B4A4-4D6C483A1699@gmail.com>
References: 
 <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
 <20505.1558202555@sss.pgh.pa.us>
 <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com>
 <cdc049f0-1980-f5a8-726a-629345b41ef0@aklaver.com>
 <3A35A039-D8F5-4B40-9B41-42E70BEF2C2E@gmail.com>
 <806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com>
 <12E9FEDD-37E9-4D51-9BA7-94FF5039BB1B@gmail.com>
 <563e995f-d7b1-7e2f-c1f1-b00db7a18589@gmail.com>
 <3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com>
 <71e50367-2375-86a8-f795-97c894728998@gmail.com>
 <3CC10064-7BF0-4600-BC67-8B6F412C9CDC@gmail.com>
 <0a8876b8-f4de-4bc2-72c8-afe5dfe6fde2@gmail.com>
To: Ron <ronljohnsonjr@gmail.com>
Precedence: bulk


> On May 20, 2019, at 5:15 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>=20
> Are there a sufficiently small number of elements in each traits =
object that you can do something like this, on the UNINDEXED table?
> SELECT traits->element1, traits->element2, count(*)
> from eis_entry
> group by traits->element1, traits->element2;
>=20
> Sure it would run for a long time, but might show you where the =
problem lies.

I don=E2=80=99t quite understand what you=E2=80=99re trying to achieve =
here. Is the intent essentially to access each individual element within =
the json on the select statement? There=E2=80=99s at least 50 elements =
in this thing, and the structure is not flat, nor is it static and =
consistent. Similar, sure. Perfectly congruent, no.