Postgres Pro
Downloads
Home   >   mailing lists

Re: Loading table with indexed jsonb field is stalling - Mailing list pgsql-general

From Will Hartung
Subject Re: Loading table with indexed jsonb field is stalling
Date
Msg-id 90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com
Whole thread Raw
In response to Re: Loading table with indexed jsonb field is stalling  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Loading table with indexed jsonb field is stalling
Re: Loading table with indexed jsonb field is stalling
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Will Hartung
Date:
Subject: Re: Loading table with indexed jsonb field is stalling
Next
From: Chuck Martin
Date:
Subject: INSERT where not exists with foreign key