Re: Loading table with indexed jsonb field is stalling

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 5/20/19 6:51 PM, Will Hartung wrote:

On May 20, 2019, at 4:27 PM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:

I'm confused.  You wrote above that loading without indexes and with just the PK works just fine; if you really need it loaded in Aurora or production, just drop the indexes beforehand?

Because the jsonb_path_ops index does not rebuild, and it’s the heart of that table.

The table is essentially worthless without that index to us.

Clarified.

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;

Sure it would run for a long time, but might show you where the problem lies.

--
Angular momentum makes the world go 'round.