Re: Loading table with indexed jsonb field is stalling

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: 2019-05-20 21:36:58
Message-ID: 806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2019-05-20 21:37:16 Re: Re: Refresh Publication takes hours and doesn´t finish
Previous Message Tom Lane 2019-05-20 21:30:04 Re: Re: Refresh Publication takes hours and doesn´t finish