Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id cdc049f0-1980-f5a8-726a-629345b41ef0@aklaver.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Will Hartung <willhartung@gmail.com>)
Ответы Re: Loading table with indexed jsonb field is stalling
Re: Loading table with indexed jsonb field is stalling
Список 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@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.

What do the below show:

1) ps ax | grep postgres

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling
Следующее
От: Will Hartung
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling