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

From Ron
Subject Re: Loading table with indexed jsonb field is stalling
Date
Msg-id 806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com
Whole thread Raw
In response to Re: Loading table with indexed jsonb field is stalling  (Will Hartung <willhartung@gmail.com>)
Responses Re: Loading table with indexed jsonb field is stalling
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Refresh Publication takes hours and doesn´t finish
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Re: Refresh Publication takes hours and doesn´t finish