Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmej-00047s-6t for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 18:05:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSmeh-0001XZ-V1 for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 18:04:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmeh-0001XI-HF for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 18:04:59 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmef-0008Tx-3B for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 18:04:58 +0000 Received: by mail-io1-xd2c.google.com with SMTP id m7so11770151ioa.6 for ; Mon, 20 May 2019 11:04:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc:message-id:references :to; bh=0t6/YlWg3nHywgCO6t9MVQ6hiu1hd4uC/eqHT7thPo4=; b=use2nuGfNBqk+neXFffqUGWZSnK3m8qtNRDiTIVjTsWP6a3/ZZVRqZrNBwyT4OxcRa 7mbYjrk408RWrDAf6GnKo11aO3PbHJZDHrfX/1jOAAQb5R+ekri9LWPZ1rI8unx9fdor xGLsdAttTNamZHemKWbbCepMn8CU9VTSe0reQZSkpmUSqc8gibLjdyogingb/Z6vyAAU auVyAdStuKB31dPZZoB1vn1IISCtZsACrhp4i1po/HU9GwiJ7/INgCacTL3Rz0rzd4xM JjF9UYALBQJpKqpM+yS6EzODs6l8Wy+ljxtC7h5LNSaSvWB7ZVUqjMNVarz3D7LlLkq6 Mp6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :message-id:references:to; bh=0t6/YlWg3nHywgCO6t9MVQ6hiu1hd4uC/eqHT7thPo4=; b=NDagWghanwesQZgRpjBr2DidgiQPQRezPTFVY6PaI+uoEy9Q0xsBGiBpYZsSZJ2lRz al7NRPNTXhgSWcuVUQ1vxOVGoc9L+2EakvywqWmqXNhbGCay+eJmA0vAtGGXveiZSc0B h2UhVDsgdFOHVjrKdbcCO8chVNcTCg8ES76qROLaXUMsOUlcduPUzFnfLyoD0wR7R6uy pQWxUTEiNxNhcsyVkXzS+s7t2sDF8CePbadu+Zo1l2/3YAMOz9mwi2Hc0kPru6dFMFT5 2Usut3mBZ8Fowyg5g7jxg+2HLnKYza5tUNNObk0FV9Pd73JXP7/FRKaHznFTtPrgLT9F fJEg== X-Gm-Message-State: APjAAAWYaHX4Z8q2nZRYEhd6tRU+qFbCN7kITYW2f+3JcOxEjX12j+Ny drxFrdqJYSw3Xtnwoi+wfes= X-Google-Smtp-Source: APXvYqylxwQe8JWZaNmPIwRnehkLn5+QDu9JnZleHrod633Hxmm0SyB30PbzmMIRCvhHUgrFdWNg+w== X-Received: by 2002:a5d:9e53:: with SMTP id i19mr6184385ioi.226.1558375495936; Mon, 20 May 2019 11:04:55 -0700 (PDT) Received: from [10.35.60.64] ([64.164.57.170]) by smtp.gmail.com with ESMTPSA id i8sm5542936ioj.26.2019.05.20.11.04.54 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Mon, 20 May 2019 11:04:55 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_EA27AF97-3D20-4149-A3AD-AD452920836A" Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) Subject: Re: Loading table with indexed jsonb field is stalling From: Will Hartung In-Reply-To: Date: Mon, 20 May 2019 11:04:53 -0700 Cc: Will Hartung , pgsql-general@lists.postgresql.org Message-Id: References: To: Adrian Klaver X-Mailer: Apple Mail (2.3124) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_EA27AF97-3D20-4149-A3AD-AD452920836A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I send this earlier, but it did not make it to the list, so I=E2=80=99m = resending it. > On May 18, 2019, at 6:55 AM, Adrian Klaver = wrote: > Is the jsonb field the only field in the table? >=20 > Can we see the table schema? # \d eis_entity Table "public.eis_entity" Column | Type | Modifiers=20 ---------------------------+--------------------------+----------- 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) |=20 searchable_trait_hash | numeric(10,0) |=20 created_date | timestamp with time zone |=20 traits | jsonb |=20 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. --Apple-Mail=_EA27AF97-3D20-4149-A3AD-AD452920836A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 I send this earlier, but it did not make it to the list, so = I=E2=80=99m 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.

= --Apple-Mail=_EA27AF97-3D20-4149-A3AD-AD452920836A--