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 1hSmfO-0004Do-5f for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 18:05:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSmfM-0004ag-N3 for pgsql-general@arkaria.postgresql.org; Mon, 20 May 2019 18:05:40 +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 1hSmfM-0004aM-AV for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 18:05:40 +0000 Received: from mail-io1-xd43.google.com ([2607:f8b0:4864:20::d43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmfK-0008VF-5E for pgsql-general@lists.postgresql.org; Mon, 20 May 2019 18:05:39 +0000 Received: by mail-io1-xd43.google.com with SMTP id g84so11795287ioa.1 for ; Mon, 20 May 2019 11:05:38 -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=0lyZ7pb57q5tw8y3gUUuG1TpNol2X7u4rOle6xry+u4=; b=OQn+2mQe6JaV0pXg/nPhcz6kL16TQPn259h8kK9spt6FIyjeK+dVl2HBXDdIWcM3ya EJ0MgXp1ngVc5Zi1ssw58Gom8D8rBGcdT3hcxqudVi86i7GqldwKlA6c4ctxTyhajtXQ AsiHVehsI2wi+6hSRPI8H1sPeNgAkzMGr57sGRT2zhqTSInt76MQU2daHqlrkdtTUi84 W2CX1BHvcm33qA/epzSsKGO/kvCNh1VtFbFYN8dpNygLcUTa77KtewetijoSZvBWyzPb cD7BitcGzOo5fPBanPo5lMy0dM20vZgYN0kA+ASI6a3o9Vcu/ivJIUvxjhwR0CraSLt7 a+qw== 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=0lyZ7pb57q5tw8y3gUUuG1TpNol2X7u4rOle6xry+u4=; b=ENX5XRcJZdJ16JzaAXHB5rt+K2xyurnAVvoBUeY0BxQmthRYCHwbvmdOEXht2ef5C0 GIBaGF1OCYKzx2WsX/8Buw26iUKkr5MLC0nV3F6TI5MAbdz+XOx/OALOqxPsotowTNjt zobSz6POn/bbCdxPSrLvpZaZLh0jPzrxY+qCZAd6yzwe4tLGF8ihM1OjxECNgMsZOVs8 KB02oKrzwFHRINu0Txt6y8RzCuXBWnEygvgIm+s2AtFvXC7HtmyCUmjDHcdyG9p314ex joh7Eastv0V340y7Iv+ako/x1XQjoSM51LKC82zeH7roW1L9FvOUSu9AOJ2wdY07GtnL HsBQ== X-Gm-Message-State: APjAAAVNSFxd7ZS7sNmQpRm8L4lPz3GIGAuW5LQWXj5RiQ20eMcvgj/q UGiBGntB4DxQ82otaUrPUi8omLS2 X-Google-Smtp-Source: APXvYqzKWqvUttQdpWKboSOY6uWmWYn8LJXqhah8PbjGyc3QTbJajDpMwj6Pva9eVNGbyylnN8Yx9w== X-Received: by 2002:a05:6602:214f:: with SMTP id y15mr6119239ioy.102.1558375537644; Mon, 20 May 2019 11:05:37 -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.05.36 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Mon, 20 May 2019 11:05:36 -0700 (PDT) Content-Type: text/plain; charset=utf-8 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: <20505.1558202555@sss.pgh.pa.us> Date: Mon, 20 May 2019 11:05:35 -0700 Cc: Will Hartung , pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com> References: <20505.1558202555@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3124) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 11:02 AM, Tom Lane wrote: >=20 > In addition to the questions about what PG version you're using, is > the backend process that's doing the load actually consuming CPU time, > or is it just sitting? It=E2=80=99s consuming both CPU and disk space. Thanks.