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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com