Re: Loading table with indexed jsonb field is stalling - Mailing list pgsql-general

From Will Hartung
Subject Re: Loading table with indexed jsonb field is stalling
Date
Msg-id A59A71A7-12CC-4B40-A507-07C887FA5620@gmail.com
Whole thread Raw
In response to Re: Loading table with indexed jsonb field is stalling  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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@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.

pgsql-general by date:

Previous
From: Will Hartung
Date:
Subject: Re: Loading table with indexed jsonb field is stalling
Next
From: Will Hartung
Date:
Subject: Re: Loading table with indexed jsonb field is stalling