Re: Loading table with indexed jsonb field is stalling

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Will Hartung <willhartung(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: 2019-05-20 18:13:07
Message-ID: cdc049f0-1980-f5a8-726a-629345b41ef0@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/20/19 11:05 AM, Will Hartung wrote:
> 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(at)sss(dot)pgh(dot)pa(dot)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.

What do the below show:

1) ps ax | grep postgres

2) As superuser:
select * from pg_stat_activity ;
>
> Thanks.
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Will Hartung 2019-05-20 18:15:59 Re: Loading table with indexed jsonb field is stalling
Previous Message Tom Lane 2019-05-20 18:12:56 Re: Loading table with indexed jsonb field is stalling