Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Will Hartung
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id 90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Loading table with indexed jsonb field is stalling  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Loading table with indexed jsonb field is stalling  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Will Hartung
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling
Следующее
От: Chuck Martin
Дата:
Сообщение: INSERT where not exists with foreign key