Re: Loading table with indexed jsonb field is stalling

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 5/20/19 9:55 AM, Will Hartung wrote:
Please reply to list also.
Ccing list.
> On Sat, May 18, 2019 at 6:55 AM Adrian Klaver <adrian.klaver@xxxxxxxxxxx 
> <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
>
>     In addition to what Tim asked:
>
>     Is the jsonb field the only field in the table?
>
>     Can we see the table schema?

Did you see Tom Lane's post?

>   # \d eis_entity
>                                 Table "public.eis_entity"
>            Column           |           Type           | Collation | 
> Nullable | Default
> ---------------------------+--------------------------+-----------+----------+---------
>   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)


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx