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

From Will Hartung
Subject Re: Loading table with indexed jsonb field is stalling
Date
Msg-id 3CC10064-7BF0-4600-BC67-8B6F412C9CDC@gmail.com
Whole thread Raw
In response to Re: Loading table with indexed jsonb field is stalling  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Loading table with indexed jsonb field is stalling
List pgsql-general

On May 20, 2019, at 4:27 PM, Ron <ronljohnsonjr@gmail.com> wrote:

I'm confused.  You wrote above that loading without indexes and with just the PK works just fine; if you really need it loaded in Aurora or production, just drop the indexes beforehand?

Because the jsonb_path_ops index does not rebuild, and it’s the heart of that table.

The table is essentially worthless without that index to us.


pgsql-general by date:

Previous
From: Will Hartung
Date:
Subject: Re: Loading table with indexed jsonb field is stalling
Next
From: Adrian Klaver
Date:
Subject: Re: Loading table with indexed jsonb field is stalling