Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id 806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Will Hartung <willhartung@gmail.com>)
Ответы Re: Loading table with indexed jsonb field is stalling  (Will Hartung <willhartung@gmail.com>)
Список pgsql-general
On 5/20/19 4:14 PM, Will Hartung wrote:
[snip]
> Also to note, I tried just loading the table with no indexes, and I was 
> getting a solid 22MB/s via iostat of just raw data load (just to proof 
> that I/O system, while certainly not extraordinary, was functional).

I think you answered this earlier, but does the same stalling happen when 
indexes are dropped?


-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Refresh Publication takes hours and doesn´t finish
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Re: Refresh Publication takes hours and doesn´t finish