From: Will Hartung <willhartung@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Will Hartung <willhartung@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: Mon, 20 May 2019 11:05:35 -0700
Message-ID: <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com> (raw)
In-Reply-To: <20505.1558202555@sss.pgh.pa.us>
References: <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
<20505.1558202555@sss.pgh.pa.us>
I send this earlier, but it did not make it to the list, so I’m resending it.
> On May 18, 2019, at 11:02 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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’s consuming both CPU and disk space.
Thanks.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: willhartung@gmail.com, tgl@sss.pgh.pa.us, pgsql-general@lists.postgresql.org
Subject: Re: Loading table with indexed jsonb field is stalling
In-Reply-To: <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox