Subject: Re: Loading table with indexed jsonb field is stalling
To: Will Hartung <willhartung@gmail.com>
References: 
 <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
 <acc82e12-6425-68a1-f7c9-c47746ee331c@aklaver.com>
 <CAKMEDdykxHQdWDaz0rW70iwdoEzQJYAOEQmupoTMoz0+TwMNbg@mail.gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <a2d2c255-9634-29e2-6e49-bffb99eb821d@aklaver.com>
Date: Mon, 20 May 2019 10:41:44 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.6.1
MIME-Version: 1.0
In-Reply-To: 
 <CAKMEDdykxHQdWDaz0rW70iwdoEzQJYAOEQmupoTMoz0+TwMNbg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

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