Re: Loading table with indexed jsonb field is stalling

[Will Hartung <willhartung@xxxxxxxxx>]

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.klaver@xxxxxxxxxxx> 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.