Re: Loading table with indexed jsonb field is stalling

[Will Hartung]

I send this earlier, but it did not make it to the list, so I’m resending it.

> On May 18, 2019, at 6:55 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:

> Is the jsonb field the only field in the table?
> 
> Can we see the table schema?

# \d eis_entity
                    Table "public.eis_entity"
          Column           |           Type           | Modifiers 
---------------------------+--------------------------+-----------
 eis_entity_key            | numeric                  | not null
 eis_identifier_domain_key | numeric                  | not null
 global_id                 | character varying(80)    | not null
 local_id                  | character varying(80)    | not null
 eis_status_key            | numeric                  | not null
 eis_entity_type_key       | numeric                  | not null
 eis_entity_domain_key     | numeric                  | not null
 all_trait_hash            | numeric(10,0)            | 
 searchable_trait_hash     | numeric(10,0)            | 
 created_date              | timestamp with time zone | 
 traits                    | jsonb                    | 
 current_revision          | numeric(8,0)             | not null
 current_version_label     | character varying(10)    | not null
Indexes:
    "eis_ent_traits" gin (traits jsonb_path_ops)

Thanks.