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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1hSsYG-0006jW-Dm
	for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2019 00:22:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1hSsYF-00060P-32
	for pgsql-general@arkaria.postgresql.org; Tue, 21 May 2019 00:22:43 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <willhartung@gmail.com>)
	id 1hSsYE-00060I-Pm
	for pgsql-general@lists.postgresql.org; Tue, 21 May 2019 00:22:42 +0000
Received: from mail-qk1-x72b.google.com ([2607:f8b0:4864:20::72b])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <willhartung@gmail.com>)
	id 1hSsYC-0007W0-MG
	for pgsql-general@lists.postgresql.org; Tue, 21 May 2019 00:22:42 +0000
Received: by mail-qk1-x72b.google.com with SMTP id z128so10012115qkb.6
        for <pgsql-general@lists.postgresql.org>;
 Mon, 20 May 2019 17:22:40 -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
         :content-transfer-encoding:message-id:references:to;
        bh=PEv753BdUteCfqSnI0J1ciqHKLdnuXB+bQAk+dFOIMw=;
        b=S4XdhODE3DPnYvZsvjR5UHLOqtXJAeSMXvdW4aeUp6lOIeWJkz/2wHNY9/B19tZ+Rl
         k5eNE416eQp4R0/kqOhGAqQEMZruHFoCkb7UzEuQu4EfzhUqs/d53HjfMJTjst0BySIv
         IED5HwikLp6JHuX9S87a12X8QS1QdeMDh8JZ62ACW6zkaK/3DGxBBJ3KB1DZNCEfbZCl
         uZ4x3AoWjx1ovkiiUFPcGf8QdhUzztoImuqA1DN+Hfuof923aGQ8IDw6GiejVAhMkDWQ
         iZB54zDPmKa/Zb4PiSrprafL4wk14fFXnFU24wxjtUtiRv+TnmMCjq2bAzP8jRW2Rz50
         VJPg==
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
         :content-transfer-encoding:message-id:references:to;
        bh=PEv753BdUteCfqSnI0J1ciqHKLdnuXB+bQAk+dFOIMw=;
        b=muFxp7w3b0lpvj6Uq4Z4Itb0iiPlXga9mSOMS/FtW+NgYg0XNUu2bulL+dWjfH5+dr
         kdB67cTx3Bh2jIqM5uEPPXEKc7DR9ubCFALx1mM1RlSaodDQt3dVFxHTOvdNLMSJbShn
         8ddYXoypbgO7d8q8YQe4Vr7Sp0UT4eaPXBKUQskhcAXtwewZOnElzOYAcQZWQRNN/M8f
         1RPW8Xy+GAki2jhJ8P6gzYRXLbeiH95rhIdPMyH40rbv94PJVBAEhrnEMl5moNVc9BWl
         L85Dra1IJVn8GH5eQfLnjyJJgn08p8515ojsM4iGtracf1PEU4FO9YuhC6t3XV+cSlrY
         rAeQ==
X-Gm-Message-State: APjAAAX5PdHc+NO13PUVoElk8T+nhvz0wh7IpcfzvM47hWQSa+nEMECR
	4ZoSR/aNlY+vzVf7tQwUEcU=
X-Google-Smtp-Source: 
 APXvYqwlcRb4lUv+EQhKy5HQhrfJTY6B0CHDIjNfzhdcKyL+nPO8N75nM/Pd7B1cn1SDeIOm18KV5Q==
X-Received: by 2002:ae9:ef0e:: with SMTP id
 d14mr59756905qkg.232.1558398159063;
        Mon, 20 May 2019 17:22:39 -0700 (PDT)
Received: from [10.35.60.64] ([64.164.57.170])
        by smtp.gmail.com with ESMTPSA id
 v3sm14202575qtc.97.2019.05.20.17.22.37
        (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128);
        Mon, 20 May 2019 17:22:38 -0700 (PDT)
Content-Type: text/plain; charset=windows-1252
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Loading table with indexed jsonb field is stalling
From: Will Hartung <willhartung@gmail.com>
In-Reply-To: <703a6c76-854d-3d1c-8be6-30864c873d05@aklaver.com>
Date: Mon, 20 May 2019 17:22:36 -0700
Cc: Will Hartung <willhartung@gmail.com>,
 Ron <ronljohnsonjr@gmail.com>,
 pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <52ACFC7C-47B8-4BF1-BDF1-8810F02BD297@gmail.com>
References: 
 <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
 <20505.1558202555@sss.pgh.pa.us>
 <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com>
 <cdc049f0-1980-f5a8-726a-629345b41ef0@aklaver.com>
 <3A35A039-D8F5-4B40-9B41-42E70BEF2C2E@gmail.com>
 <806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com>
 <12E9FEDD-37E9-4D51-9BA7-94FF5039BB1B@gmail.com>
 <563e995f-d7b1-7e2f-c1f1-b00db7a18589@gmail.com>
 <3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com>
 <7c0a001e-d3d5-c521-1a27-77d05f547fef@aklaver.com>
 <375E86FF-5B4D-4896-B4ED-FCA8C1D3A60B@gmail.com>
 <703a6c76-854d-3d1c-8be6-30864c873d05@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
X-Mailer: Apple Mail (2.3124)
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Precedence: bulk


> On May 20, 2019, at 5:14 PM, Adrian Klaver <adrian.klaver@aklaver.com> =
wrote:
>=20
> Well looks like you are down to Tom's suggestion of creating a test =
case. Given that it seems confined to the jsonb field and corresponding =
index, I would think that is all that is needed for the test case. Start =
with some smaller subset, say 10,000 rows and work up till you start =
seeing an issue.

This will take quite some work, and I wouldn=92t attempt it with less =
than 5M rows to load.