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 1hSs3u-00054W-6W for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 23:51:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSs3s-0003oV-R3 for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 23:51:20 +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 1hSs3s-0003oL-DZ for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 23:51:20 +0000 Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSs3p-0007r5-3m for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 23:51:18 +0000 Received: by mail-qt1-x842.google.com with SMTP id a17so18492765qth.3 for ; Mon, 20 May 2019 16:51:17 -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=dCioQ9OT7D9Ugj61MBRrDoRs6rVp69u16lCT6wJV3K4=; b=hRaglpnnKWvaf8Uxj4sb4AE7znSaxXFqvNNqnFKWqLAuUdvDdClP124HDl5LfJ6cUv x5sHB9HNM+wgznprWExQrbhMCgD5HIzA/K5cQ1TRgumZcL9InqkzQVO8HD+E5MgsWJ9U zZKRZxuz2BqzCcIrv/9OibLfqgYB6hK6P8OedgSdEUsxM0X/Ky3dai/vfi9k1SJadZV/ tEB5S+l28ncMAOTc9S+QtJhROJn3YGP+sI3lPgYmrV678rbrxUT6JrSjVt6GPfF/vxqN I77rkBHcfN0CN2Jnzey80t5Mo4G+0QLSBhMVHvrb55E4hoxR1wwBEqCqd+YOvHj/QjXH e0ww== 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=dCioQ9OT7D9Ugj61MBRrDoRs6rVp69u16lCT6wJV3K4=; b=n3Re+XwZKitP4kl3fuOkb4HQ4v4NbZMi0O+ywgtpWQSkvCFKDNLZexMe5G7Q2t+7+u 4ihz0Fqc9hNXiinYUfBOQt8tYzM9KePaOfFes/KCwKF4g7lKgIhukob5DvNZYm4M18ap ah9wtz2MWt0qZAj6BJAuWgv4F37QTA7AVSmKGDlXh6Tu+jtZFNZ9R4z8etL4opxBg83c C2jNbSpOUKq4Z1MVcttywfqRZn1go7RqZ0/WkIiLa5dWS4G9Frw1aY7yO0HAfcE/MGwG JD2wpOir05M/R23ZStkLZ17zm5/SMwPrcVVobktNwSESlQw4cNCCZ/J9YXeQwSWRdor/ DQWg== X-Gm-Message-State: APjAAAV4ZaUJTbR4+OYi/Xt60YqdUCdFxouopPYX3mUZ/z3UDu+i7qDf GE1k8e4KOzgp6zjr7FNHMw2E8hQR X-Google-Smtp-Source: APXvYqxrdpZ9ZUc9B/RPj1lHCI7hBJamVEPwe1pS0E+Yhgo6Dp22Cht5Htq7OKFlZjZcUVAb6EeJ2Q== X-Received: by 2002:a0c:932f:: with SMTP id d44mr55072104qvd.187.1558396276365; Mon, 20 May 2019 16:51:16 -0700 (PDT) Received: from [10.35.60.64] ([64.164.57.170]) by smtp.gmail.com with ESMTPSA id t63sm8356748qka.33.2019.05.20.16.51.15 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Mon, 20 May 2019 16:51:15 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_04D6D079-66BB-4F7A-9F03-FCF465698886" 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: <71e50367-2375-86a8-f795-97c894728998@gmail.com> Date: Mon, 20 May 2019 16:51:13 -0700 Cc: pgsql-general@lists.postgresql.org Message-Id: <3CC10064-7BF0-4600-BC67-8B6F412C9CDC@gmail.com> References: <20505.1558202555@sss.pgh.pa.us> <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.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> <71e50367-2375-86a8-f795-97c894728998@gmail.com> To: Ron X-Mailer: Apple Mail (2.3124) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_04D6D079-66BB-4F7A-9F03-FCF465698886 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On May 20, 2019, at 4:27 PM, Ron wrote: >=20 > I'm confused. You wrote above that loading without indexes and with = just the PK works just fine; if you really need it loaded in Aurora or = production, just drop the indexes beforehand? Because the jsonb_path_ops index does not rebuild, and it=E2=80=99s the = heart of that table. The table is essentially worthless without that index to us. --Apple-Mail=_04D6D079-66BB-4F7A-9F03-FCF465698886 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
On May 20, 2019, at 4:27 PM, Ron <ronljohnsonjr@gmail.com> wrote:

I'm confused.  You wrote above that loading without indexes and = with just the PK works just fine; if you really need it = loaded in Aurora or production, just drop the indexes beforehand?

Because = the jsonb_path_ops index does not rebuild, and it=E2=80=99s the heart of = that table.

The table is essentially = worthless without that index to us.


= --Apple-Mail=_04D6D079-66BB-4F7A-9F03-FCF465698886--