Re: Loading table with indexed jsonb field is stalling

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@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> 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@aklaver.com