Re: Loading table with indexed jsonb field is stalling

From: Will Hartung <willhartung(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: Will Hartung <willhartung(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: 2019-05-20 22:43:42
Message-ID: 3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On May 20, 2019, at 2:55 PM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> And it pathologically loads even when there's just a PK on the numeric field?

Yea, that works fine.

> Drop all indexes, load data, recreate indexes?

No, I use the incremental load as it gives a much better indication when the process has gone off the deep end.

> But pg_restore only creates indexes AFTER the data loads.

Yes. Demonstrating that it doesn’t work either incrementally or all at once.

(No, I have no confidence that the Aurora build will ever finish in any reasonable amount of time.)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-05-20 23:27:07 Re: Loading table with indexed jsonb field is stalling
Previous Message Ron 2019-05-20 21:55:42 Re: Loading table with indexed jsonb field is stalling